The Pivot option moves a dimension on the row axis to the column axis, or vice versa. You can pivot data by using the right-click menu.
To pivot data:
![]() |
When pivoting from the right-click menu, row headings move to the column axis and column headings move to the row axis. You cannot pivot to or from the page axis with the right-click menu. This option only works on single headings; it does not work with multiple headings. |