Excel Pivot Table: Multiple Rows at the Same Level

Yes. In Excel for Microsoft 365 on Windows, add each field to the PivotTable Rows area, then choose PivotTable Design > Report Layout > Show in Tabular Form to display the row fields in separate columns. The fields still define a nested grouping, but tabular layout makes them look like columns at the same level; use Repeat All Item Labels if you want every row to show its labels.

What “same level” means in a PivotTable

The phrase “multiple rows at the same level” can mean two different things. It may mean that you want more than one row field—for example, Region and Salesperson—to appear as separate columns in the PivotTable. Or it may mean that you want the fields to behave as independent, unrelated categories, rather than one category being grouped within another. Excel can make the first arrangement easy to read, but the second is not what adding multiple fields to Rows does.

A PivotTable organizes row fields as a hierarchy. When Region and Salesperson are both in Rows, Excel groups salespeople within regions. Changing the report layout changes how that hierarchy is displayed; it does not remove the grouping relationship. This distinction matters when you interpret subtotals, expand or collapse groups, or compare totals.

In Compact Form, Excel places multiple row fields in one displayed column, often with indentation. In Tabular Form, each row field gets its own column. Outline Form also uses separate columns, but presents the grouped report with a more hierarchical appearance. These are display choices for the same PivotTable structure.

Show multiple row fields in separate columns

To make the row fields easier to scan, start with a PivotTable that already contains the fields you want:

Click a cell inside the PivotTable so the contextual PivotTable tabs appear.
In the PivotTable Fields pane, drag each desired field into the Rows area. For example, place Region first and Salesperson beneath it.
On the ribbon, select PivotTable Design > Report Layout > Show in Tabular Form. Excel displays each row field in its own column.
If labels appear only on the first row of a group, select PivotTable Design > Report Layout > Repeat All Item Labels.
If you do not want a subtotal line for each outer group, select PivotTable Design > Subtotals > Do Not Show Subtotals.

These settings can be combined. For instance, Tabular Form plus repeated labels gives a straightforward table-like layout, while turning off subtotals removes intermediate summary rows. You can leave subtotals on if they are useful; they are not required for the fields to appear in separate columns.

In Excel for Mac, select the PivotTable and look for the contextual Design tab and its Report Layout options; ribbon organization can differ slightly by version. In Excel for the web, available PivotTable layout controls can depend on the current web experience, so use the desktop app if a needed Design command is not shown.

How row-field hierarchy affects the result

Imagine a source table with columns for Region, Salesperson, Product, and Sales. If you put Region and Salesperson in Rows and Sales in Values, Excel calculates sales for each salesperson within each region. The region is the outer grouping and the salesperson is the next level. Adding Product below Salesperson creates another level, so the report can show products within salespeople within regions.

Moving a field higher or lower in the Rows area changes the hierarchy. If Salesperson is above Region, Excel groups by salesperson first and then by region. The displayed columns can still be separate in Tabular Form, but the order changes what groups and subtotals mean. To reorder fields, drag them within the Rows area of the PivotTable Fields pane.

Also distinguish row fields from value fields. A field in Rows supplies labels that define groups; a field in Values is summarized, usually as a sum or count. Putting two numeric fields in Values creates two measures, not two row labels. If a numeric field appears as “Sum of Sales” in the report, it is being summarized rather than used to define a row category.

Example: Region and salesperson side by side

Suppose the source records include North, South, and West regions, with several salespeople in each region. Add Region and Salesperson to Rows, then add Sales to Values. In Compact Form, the two labels may appear together in one column, with the salesperson visually indented under the region. This can be compact, but it may be inconvenient if you want to sort, filter, copy, or compare the fields as separate columns.

Switching to Tabular Form gives you a Region column and a Salesperson column. With repeated labels turned on, a salesperson row might show “North” and “Avery” on the same line, followed by “North” and “Jordan” on the next. The Sales column shows each person’s summarized amount. Excel still treats both people as members of North; repeating “North” is a display convenience, not a change to the data model.

This layout is often easier to copy into another worksheet or use as a report, but remember that a PivotTable is a summary, not a plain data range. It may include subtotal and grand-total rows, and the number of displayed records depends on the grouping and filters. If you need a clean list of every original transaction, use the source table rather than treating a summary PivotTable as a complete record-level export.

Choose between Compact, Outline, and Tabular Form

Excel offers three report layouts because different reports have different priorities. Choose based on how readers will use the result, not on the idea that one layout changes the underlying calculation:

Compact Form: Multiple row fields share one displayed column. It saves horizontal space and makes nested groups visually clear, but it can be less convenient when each field needs its own column.
Outline Form: Row fields use separate columns, with a layout that emphasizes the group structure. It can suit reports where the hierarchy and group sections matter.
Tabular Form: Each row field appears in a separate column, making the report more table-like. It is often the clearest choice when readers need to scan or copy field labels side by side.

Changing among these layouts does not convert a PivotTable into unrelated flat dimensions. Filters, field order, subtotals, and the selected summary calculation still shape the report. If readers need repeated labels for every visible record, turn on the repeat-label option and check whether subtotal rows are still wanted.

Common problems and how to fix them

All row fields appear in one column. The report is probably in Compact Form. Select PivotTable Design > Report Layout > Show in Tabular Form to separate the fields into columns.

Some label cells look blank. In a grouped report, Excel may show a group label only once rather than repeating it on every detail row. Choose Repeat All Item Labels from Report Layout. This improves readability, but does not fill blank cells in the source data or change the grouping.

Unexpected subtotal rows appear. The outer row fields may have subtotals enabled. Use PivotTable Design > Subtotals > Do Not Show Subtotals to suppress them for the report, or change the subtotal setting for a particular field if you want to retain selected summaries. Grand totals are controlled separately under the Design tab’s Grand Totals menu.

A row field is missing or in the wrong place. Check the PivotTable Fields pane. A field in Filters, Columns, or Values will not serve as a row label. Drag it to Rows and arrange the row fields in the intended outer-to-inner order. If the source table has changed, refresh the PivotTable; if a new source column is absent from the field list, check that the PivotTable’s source range includes it.

The report has repeated combinations or unexpected counts. Review the source data for duplicate records and check which fields are in Rows and Values. A PivotTable aggregates records according to the fields and summarization settings; it does not assume that a person, product, or transaction is unique unless the source structure supports that assumption.

When a flat table or another tool is a better fit

If your goal is simply to display each source record with several descriptive columns and no aggregation, use the original Excel table or a filtered copy of it. A PivotTable is designed to group and summarize. Even when Tabular Form looks like a conventional grid, the report can contain grouped summaries, subtotals, and grand totals rather than one row per source record.

If you need a reusable, reshaped dataset, Power Query may be a better option. It can transform columns and rows before loading the result to a worksheet or Data Model. If you need fields to behave as independent dimensions in a more involved analytical report, consider how the source tables and relationships are modeled in the Data Model rather than relying only on the visible PivotTable layout. For a simple report, however, multiple fields in Rows with Tabular Form is usually the quickest approach.

Frequently Asked Questions

Can I put two fields in the Rows area?
Yes. Drag both fields into Rows. Excel treats them as successive grouping levels, and you can display them in separate columns by choosing Show in Tabular Form.

Does Tabular Form make row fields truly independent?
No. It changes the report’s appearance, not the grouping logic. The fields still define a hierarchy in the order shown in the Rows area.

How do I repeat a group name on every row?
Select a cell in the PivotTable, then choose PivotTable Design > Report Layout > Repeat All Item Labels. The option is useful in tabular reports where you want each visible row to carry its group label.

Can I remove subtotal rows but keep the row fields?
Yes. Choose PivotTable Design > Subtotals > Do Not Show Subtotals. The row fields remain, but Excel stops inserting their subtotal lines.

Why does my PivotTable still look nested after I change layouts?
Because the fields are still grouped in a hierarchy. Tabular Form separates their columns; it does not remove parent-and-child relationships or turn the summary into a flat list of source records.

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.