How do you transpose a row of data to a column in Excel?
- Select and copy the row data.
- Go to the top cell of the column where you would like to copy the data.
- Click on copy - transpose.
- Observe the data from the row in the column.
- Go back and delete the row data.