Excel Pivot Table Rows Side by Side: Layout, Steps, and Tips

To put PivotTable row fields side by side in Excel for Microsoft 365 on Windows, click inside the PivotTable and choose PivotTable Design > Report Layout > Show in Tabular Form. Each row field then gets its own column instead of being nested in one indented column; choose Repeat All Item Labels if you want the labels repeated on every detail row.

What side-by-side rows mean in a PivotTable

Excel’s default Compact Form can make a PivotTable look as though its row fields are stacked together. For example, if Region and Product are both in the Rows area, Compact Form puts both levels in a single column. A product appears indented beneath its region, and the region label may appear only once for a group. This saves horizontal space, but it is not always convenient for reading, copying, or further analysis.

Tabular Form changes that layout: Region appears in one column and Product in another. Each combination occupies a row, so a table might show West in the first column and Desk in the second, followed by West and Chair on the next row. The fields are still part of one PivotTable hierarchy; they have not become independent lists or separate PivotTables.

The phrase side by side can also mean putting measures or categories in adjacent columns. That is a different layout choice. To show row fields in separate columns, change the report layout. To compare values across columns, use the Columns area in the PivotTable Fields pane. Knowing which meaning you intend prevents changing the wrong setting.

Change the report layout to Tabular Form

These steps apply to Excel for Microsoft 365 on Windows. The contextual PivotTable Design tab appears when a PivotTable is selected.

Click any cell inside the PivotTable. If the PivotTable Fields pane is not visible, use PivotTable Analyze > Field List to show it.
In the Fields pane, check that the categories you want as separate row columns are in the Rows area. Drag fields into the desired order; the first field becomes the outer grouping.
Select PivotTable Design > Report Layout > Show in Tabular Form.
If labels should appear on every row, select PivotTable Design > Report Layout > Repeat All Item Labels.
Review the result, adjust column widths if needed, and decide whether group subtotals help or distract from the detail.

For example, suppose a sales PivotTable has Region and Product in Rows and Sum of Sales in Values. In Tabular Form, the output has separate Region and Product columns and a Sales column. If the West region includes Desk sales of $4,000 and Chair sales of $2,500, those products can occupy separate rows under West. Repeating labels displays West on both rows; without repetition, the region cell may be blank on the second row even though the row remains part of West’s group.

On Excel for Mac, select the PivotTable and look for the contextual PivotTable Design tab and its Report Layout menu; ribbon placement can vary by release. Excel for the web has a more limited and changing set of PivotTable controls. If the report-layout command is not available there, open the workbook in the desktop app to apply the layout.

Choose between Compact, Outline, and Tabular Form

The three report layouts change how row fields are displayed, not which source records are included. Compact Form is Excel’s space-saving default: several row fields share one column. It works well for a small, hierarchical summary when indentation makes the grouping easy to follow.

Outline Form gives each row field its own column, like Tabular Form, but presents the hierarchy with a more outline-oriented arrangement. Tabular Form is usually the clearest choice when the goal is a conventional grid with one field per column. It is often easier to filter, scan, copy, or export than a compact, indented display.

Compact Form: one column for row fields; useful for a narrow, nested report.
Outline Form: separate columns for row fields, with an outline-style grouping presentation.
Tabular Form: separate columns for row fields, suited to a table-like report.

Subtotals are a separate choice from the report layout. A PivotTable can still show a subtotal for each region in Tabular Form. To manage them, use PivotTable Design > Subtotals and choose the option that fits the report. Grand totals can be adjusted separately under PivotTable Design > Grand Totals. If extra summary rows make the side-by-side list harder to read, turn off subtotals or change their placement rather than switching back to Compact Form.

Keep group labels visible on every row

In a hierarchical PivotTable, Excel may show a group name once and leave the corresponding cells visually blank on following detail rows. This is a display convention, not missing source data. It can be inconvenient when someone copies the PivotTable, uses it as a reference, or expects every record-like row to carry its own category labels.

Use PivotTable Design > Report Layout > Repeat All Item Labels after choosing Tabular Form. This repeats labels for the row fields in the report. If the option is unavailable or has no visible effect, check that the PivotTable has multiple row fields and that it is displayed in a layout that supports separate field columns. Also distinguish repeated item labels from repeated source records: the setting changes presentation, not the underlying data or the aggregation.

Repeated labels make a PivotTable more readable as a grid, but they do not turn it into a normal Excel Table. The cells are still PivotTable output. Sorting or editing individual cells in the report is restricted because Excel generates the layout from the PivotTable fields and source data.

Show categories or measures side by side

If you want months, regions, or other categories across the top of the report, drag that field into the Columns area instead of changing the row report layout. For instance, placing Region in Columns and Product in Rows can display separate regional value columns for each product. This arrangement is useful for comparing categories horizontally, though a large number of column items can make the PivotTable wide.

To display two measures side by side, add both numeric fields to the Values area. Excel will create a value column for each measure, such as Sum of Sales and Sum of Units. If there are also fields in Columns, Excel may place the Values field in the Columns area automatically; you can rearrange it in the Fields pane to control the order. These settings are independent of whether the row labels use Compact, Outline, or Tabular Form.

A practical design often uses one or two descriptive fields in Rows, a date or comparison category in Columns, and one or more measures in Values. Keep the number of column items manageable. If a report becomes too wide, move a category back to Rows or use a filter to focus on a smaller set of items.

Why the layout may not look as expected

When the command seems to do nothing, first confirm that the active cell is inside the PivotTable. The PivotTable Design tab is contextual and may disappear when you select a cell outside the report. Then check the Fields pane: a field must be in Rows to appear as a row label, and a field in Filters or Columns will not become a row column just because you selected Tabular Form.

Still one row-label column: verify that you selected Show in Tabular Form, not Show in Compact Form, and check that more than one field is in Rows.
Labels appear blank below the first item: choose Repeat All Item Labels if repeated labels are needed.
Extra subtotal rows appear: adjust Subtotals on the PivotTable Design tab.
A field is missing: check whether it is unchecked or placed in another area of the Fields pane.
The report changed after refresh: refresh can bring in new source items or updated values, so review filters, grouping, and column widths afterward.

Another common misconception is that changing the layout changes the calculation. It does not. Sum, Count, Average, filters, and source records remain governed by the PivotTable’s fields and value settings. The report layout controls where row labels appear and how their hierarchy is presented.

When to use a PivotTable or a regular table

Use a PivotTable when you need to summarize a changing dataset by categories, calculate totals, and rearrange the analysis quickly. Tabular Form provides separate row-field columns while retaining PivotTable features such as filtering, grouping, and refresh. If the source data changes, refresh the PivotTable so its summary reflects the latest records.

Use a normal range or Excel Table when you need to edit each displayed row directly, maintain a fixed record-by-record structure, or apply formulas and formatting to individual output cells. PivotTable cells are generated results, so typing over one is generally not a sound way to change a category or total. Make the change in the source data, then refresh.

For a one-time handoff, a copy of the PivotTable can be pasted as values into another range, but that copy will no longer update as a PivotTable. Keep the original report if refreshable analysis matters. Also check that the source data has clear column headings and consistent field values; inconsistent spellings such as North and Noth will appear as separate PivotTable items regardless of the chosen layout.

Frequently Asked Questions

How do I put two row fields in separate columns in Excel?
Place both fields in the Rows area, click inside the PivotTable, and choose PivotTable Design > Report Layout > Show in Tabular Form. Each row field then has its own column.

How do I repeat row labels in a PivotTable?
Choose PivotTable Design > Report Layout > Repeat All Item Labels. This repeats the group labels in the displayed rows; it does not add records to the source data.

How do I put months side by side in a PivotTable?
Drag the month field to the Columns area in the PivotTable Fields pane. That places month categories across the top; Tabular Form instead separates row fields into columns.

Can I show two totals side by side?
Yes. Drag both numeric fields into the Values area. Excel displays a value column for each measure, subject to the other fields and layout in the PivotTable.

Why are some PivotTable row labels blank?
Excel may display a group label only on its first detail row. Use Repeat All Item Labels to show it on each row, or leave the compact display if the indentation already makes the hierarchy clear.

Choose the layout that matches the question

For a readable, table-like report with multiple row categories, Tabular Form is usually the direct answer: it gives each row field its own column. Repeat labels when the report needs to stand on its own as a clear grid, and adjust subtotals independently. If the real goal is comparing months, regions, or measures horizontally, use the Columns or Values area instead. Those distinctions let you make the PivotTable easier to read without changing what it calculates.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.