Transposing rows and columns
- Activate the pivot table.
- From the menus choose:
This has the same effect as dragging all of the row elements into the column dimension and dragging all of the column elements into the row dimension.
This has the same effect as dragging all of the row elements into the column dimension and dragging all of the column elements into the row dimension.