- Select the data in the row that you want to transpose.
- Copy the data (press Ctrl + C or right-click and select Copy).
- Select the destination cell where you want the transposed data to
appear.
- Right-click on the destination cell and choose Paste Special.
- In the Paste Special dialog box, check the Transpose option at the
bottom.
- Click OK.
Your row data will now be pasted as a column.