Pivot Table Issues

How to Display Multiple PivotTable Fields in the Same Row in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 12, 2026 869 views

Question details

The user needs to display several PivotTable fields in separate columns on the same row instead of using a compact hierarchical layout.

How to Display Multiple PivotTable Fields in the Same Row in Excel
Product
Microsoft Excel PivotTable
Device & OS
not provided
Scenario
The PivotTable contains fields such as serial number, fan, low, and core, and the user wants each field displayed on one line in its own column.
Observed behavior
Multiple fields appear in a compact hierarchical layout, making them display under a single row label rather than as separate columns.
Before you start

Click any cell inside the PivotTable so that the PivotTable tools and Design tab become available. Identify whether you also want to remove subtotal rows after changing the report layout.

Solution 1Recommended

Show PivotTable fields in separate columns with Tabular Form

Use this solution when multiple row fields are grouped into a compact hierarchy and need to appear across the same row.

Tabular Form gives each row field its own column, making fields such as serial number, fan, low, and core easier to read and export. You can optionally hide subtotal rows for a cleaner list.

1
Select the PivotTable

Click any cell inside the Excel PivotTable to activate the PivotTable tools.

2
Open the Design tab

On the Excel ribbon, select the Design tab under PivotTable Tools.

3
Change the report layout

Choose Report Layout, then select Show in Tabular Form. Each row field will display in a separate column.

4
Remove subtotal rows if needed

On the Design tab, select Subtotals, then choose Do Not Show Subtotals to hide extra subtotal lines.

Expected result: The selected PivotTable fields appear as separate columns on the same row, with subtotal rows removed if that option was selected.

Create a clear tabular PivotTable layout in WPS Spreadsheets

WPS Spreadsheets provides familiar PivotTable layout controls for organizing multiple row fields into separate columns. Use the PivotTable design tools to select a tabular report layout and manage subtotal rows.

  1. 1. Open the workbook: Launch WPS Spreadsheets and open the XLSX workbook containing the PivotTable.
  2. 2. Select the PivotTable: Click inside the PivotTable to display the PivotTable tools and layout options.
  3. 3. Choose a tabular layout: Open the PivotTable Design or Layout tab, select Report Layout, and choose Show in Tabular Form if available.
  4. 4. Manage subtotals: Use the Subtotals control and select Do Not Show Subtotals when you want to remove extra subtotal rows.
Display multiple PivotTable fields in separate columns for easier readingHide unnecessary subtotal rows from the PivotTable layoutUse a lightweight spreadsheet interface with familiar Office-style controlsOpen and edit Microsoft Excel XLSX PivotTable workbooks with broad format compatibility
microsoft office alternative - wps office

Frequently Asked Questions

Why are several PivotTable fields displayed in one hierarchical column?

Excel uses Compact Form by default, which groups multiple row fields under one Row Labels column. Select the PivotTable, open Design, choose Report Layout, and select Show in Tabular Form.

How can I remove subtotal rows from an Excel PivotTable?

Click inside the PivotTable, open the Design tab, select Subtotals, and choose Do Not Show Subtotals.

Will Show in Tabular Form place every field in its own column?

Yes. Row fields are displayed in separate columns instead of being nested in a single compact hierarchy.

Can I keep the PivotTable fields in columns but retain subtotals?

Yes. Choose Show in Tabular Form under Design > Report Layout, then leave the Subtotals setting unchanged or select a preferred subtotal position.