The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

Rather than retype your data or rearrange it one cell at a time, you can transpose your rows and columns with a special twist on a familiar Excel command.

3] Transpose columns and rows Some people create Excel spreadsheets where the main fields go across horizontally in a row. Others put the data vertically.