How do you transpose a row of data to a column in Excel?

  1. Select and copy the row data.
  2. Go to the top cell of the column where you would like to copy the data.
  3. Click on copy - transpose.
  4. Observe the data from the row in the column.
  5. Go back and delete the row data.