The Data | Data | Transpose command rearranges data from columns to rows or from rows to columns. To quickly switch the layout of your data, highlight the data that should be flipped. Click the Data | Data | Transpose command and the columns become rows and the rows become columns.
For example, consider the following data:
Categories A, B, and C are displayed with each category in a row.
Highlight the rows 1-4. Click the Data | Data | Transpose command and the data appears in columns:
Categories A, B, and C are now displayed with each category in a separate column.
Data Tab Commands