How to Change a PivotTable Layout from Rows to Columns in WPS Office Spreadsheets
Question details
The user wants to change a PivotTable in WPS Office Spreadsheets so fields appear in columns instead of rows.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Working with a PivotTable, the user needs to rearrange the field display orientation from rows to columns.
- Observed behavior
- After changing the layout, the PivotTable fields should appear in a column-based arrangement.
Open your workbook in WPS Office Spreadsheets and click any cell inside the PivotTable so the PivotTable Tools tabs and Fields pane are available.
Switch the PivotTable layout to Tabular Form and arrange fields in columns
Use this when you want the PivotTable labels to appear side by side in columns instead of stacked in rows.
Tabular Form shows each row field in a separate column, which creates a table-like layout similar to a standard spreadsheet. You may still need to move fields to the Columns area to fully change their orientation.
Open your workbook in WPS Office Spreadsheets and click any cell inside the PivotTable. The PivotTable Tools tabs appear on the ribbon.
Go to the PivotTable Tools > Design tab, click Report Layout, and choose Show in Tabular Form.
In the PivotTable Fields pane, drag the field you want to display as columns from the Rows area to the Columns area.
Check the PivotTable. If needed, click Refresh on the PivotTable Tools > Analyze tab to update the layout.
Drag specific fields between Rows and Columns in the PivotTable Fields pane
Use this method when only certain fields need to move from rows to columns and the overall report layout can remain unchanged.
Change PivotTable Rows to Columns in WPS Office Spreadsheets
WPS Office Spreadsheets lets you apply Tabular Form and move fields between Rows and Columns in the PivotTable Fields pane, so you can create a column-based PivotTable layout without changing your source data.
- 1. Open your workbook: Launch WPS Office Spreadsheets and open the .xlsx workbook containing the PivotTable.
- 2. Select the PivotTable: Click any cell inside the PivotTable to activate the PivotTable Tools tabs.
- 3. Apply Tabular Form: On the Design tab, click Report Layout and select Show in Tabular Form.
- 4. Move fields to columns: In the PivotTable Fields pane, drag fields from Rows to Columns or rearrange them until the layout shows the desired column arrangement.
- 5. Save the file: Click the Save icon or press Ctrl+S to keep the updated layout in WPS Spreadsheets.
Frequently Asked Questions
How do I open the PivotTable layout options in WPS Office Spreadsheets?
Click any cell inside the PivotTable, then go to the PivotTable Tools > Design tab and use the Report Layout menu.
What does Tabular Form do in a WPS PivotTable?
Tabular Form places each row field in its own column, creating a table-like layout instead of the default compact row hierarchy.
Why are my fields still showing in rows after I apply Tabular Form?
Tabular Form affects label display, but you also need to drag fields from the Rows area to the Columns area in the PivotTable Fields pane to change their orientation.
Can I change a PivotTable layout without losing data?
Yes, layout changes only reorganize the summary display. Source data and calculated totals remain intact.
Is this layout change compatible with Microsoft Excel files?
WPS Spreadsheets supports .xlsx PivotTables, so the layout and field arrangement are preserved when you reopen the file in Microsoft Excel.
