Swap Columns and Rows

Swap columns and rows to look at information from a different perspective. This may help you discover high and low points in the data that you hadn't previously noted.

You can only swap columns and rows in a crosstab or chart. In a chart, you swap the x- and y-axes.


From the toolbar, click the swap rows and columns button swap rows and columns icon.


In the report, the rows become the columns and the columns become the rows.