Transposing Table Rows and Columns

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.

 

Before Transposing

images\ebx_258174024.gif

 

After Transposing

images\ebx_-1160800756.gif

 

Any changes to the data prior to transposing will still be maintained except if the data is sorted. Sorted data cannot be transposed.

 

Transpose

1.    From the table view, click modify table, located in the action menu above the table

 

images\ebx_1870944875.gif

 

2.    Click transpose rows and columns

 

images\ebx_1033210120.gif

 

Note: Click reset table to restore the table to its original format

 

Error Messages

You may encounter some of the following errors relating to transposing table rows and columns.

 

Unable to transpose unless sort is undone

Sorted tables cannot be transposed. To transpose the table click reset table and then click transpose rows and columns

 

 

See Also

Filtering Rows

Hiding and Unhiding Rows and Columns

Reordering Table Columns

Sorting Rows

Tables Overview