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.

Procedure

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

Results

In the report, the rows become the columns and the columns become the rows.
Parent topic: Crosstabs