The transpose feature is used to rotate a row data to a column or vice versa, there are different ways to do it, two methods are being discussed here.
Paste Special Transpose
For this, do these steps:
1- Select a row to rotate.
- Press Ctrl + C.
- Click Right and select Copy
4- To open Paste Special window, do one of following:
- Press Alt + E + S or Ctrl + Shift + V.
- Select the Transpose option from the open window. (You may also press E button to do the same action).
To get the same result as above, the Transpose function is another way to do this.
1- Select the cell where you want to paste to transpose.
2- Press + button or = sign and type Transpose.