Below are steps on how to change a pivot table into tabular
-
Click anywhere in the PivotTable.
This displays the PivotTable Tools, tab on the ribbon.
-
On the Design tab, in the Layout group, click Report Layout, and then do one of the following:
-
To keep related data from spreading horizontally off of the screen and to help minimize scrolling, click Show in Compact Form.
In compact form, fields are contained in one column and indented to show the nested column relationship.
To outline the data in the classic PivotTable style, click Show in Outline Form.
-
To see all data in a traditional table format and to easily copy cells to another worksheet, click Show in Tabular Form.
-