How to Change Pivot Table in Tabular Form

When you first create a Pivot Table with multiple row items, the default layout for the Pivot Table is Compact Form, which lists all row items in one column and saves more spaces to numeric data. While Tabular Form displays one column per field and provides space for field headers.

To display your Pivot Table layout to the Tabular form, please see steps below:

Step 1: Click any cell within the Pivot Table;

Step 2: Click "Design" Tab from the Ribbon;

Step 3: Click "Report Layout" in the "Layout" section;

Step 4: Click "Show in Tabular Form" from the drop-down list;

Step 5: The Pivot table will change to the Tabular form.

Leave a Reply