Swap the rows and columns of a table using the transpose rows and columns button. The original column headers are row headers and the original row headers are column headers. In the example below the row headers; Male and Female become column headers after transposing. To switch the table back to the original format, transpose the table again or click the reset table button in the action toolbar.
See the Transpose Rows and Columns tutorial for more information.
Any changes to the data prior to transposing will still be maintained except if the data is sorted. Sorted data cannot be transposed.
1. From the table view, click modify table, located in the action menu above the table
2. Click transpose rows and columns
Note: Click reset table to restore the table to its original format
You may encounter some of the following errors relating to transposing table rows and columns.
Sorted tables cannot be transposed. To transpose the table click reset table and then click transpose rows and columns
Hiding and Unhiding Rows and Columns
Reordering Table Columns