To put PivotTable row fields next to each other in separate columns, select the PivotTable and choose Design > Report Layout > Show in Tabular Form. To show the item name on every row instead of leaving repeated cells blank, also choose Design > Report Layout > Repeat All Item Labels.
What “side by side” means in a PivotTable
A PivotTable can display several fields in its Rows area in different ways. In the default Compact Form, Excel nests the row fields in a single column. For example, if Region and Salesperson are both row fields, the table may show a region heading and then salesperson names indented beneath it. That layout is compact, but it can be awkward to read, filter, or copy into another table.
Tabular Form gives each row field its own column. Region appears in one column and Salesperson in the next, with the value field—such as Sum of Sales—in another column. This is usually what people mean when they ask to put PivotTable rows or row labels side by side. It changes the report’s display; it does not change the source data or turn the PivotTable into multiple independent tables.
There is a related but different meaning: placing categories horizontally across the top of a PivotTable. For that, move a field from the Rows area to the Columns area in the PivotTable Fields pane. Tabular Form changes how row fields are arranged; moving a field to Columns changes which fields define the horizontal headings.
Change the report layout in Excel for Microsoft 365
In Excel for Microsoft 365 on Windows, use these steps:
- Click any cell inside the PivotTable. The contextual PivotTable Analyze and Design tabs appear on the ribbon.
- Select Design > Report Layout > Show in Tabular Form.
- If you want each row label shown on every record line, select Design > Report Layout > Repeat All Item Labels.
- Check the column headings and totals. If the table still has unwanted group headings or blank lines, adjust the layout and subtotal options described below.
The report-layout choice applies to the selected PivotTable. It does not rearrange the worksheet’s source range. If you have more than one PivotTable, change each one separately. When you click outside the PivotTable, its contextual tabs disappear; click back inside it to access the commands.
How the Rows area controls the result
The PivotTable Fields pane determines which fields are used and in what order. Fields placed in Rows define the categories listed down the left side. Their order matters: with Region above Salesperson, each salesperson is grouped under a region. Dragging Salesperson above Region reverses that hierarchy. Tabular Form makes the fields separate columns, but it does not remove the hierarchy or change the underlying grouping.
For a simple example, imagine a source list with Region, Salesperson, and Sales columns. Put Region and Salesperson in Rows and Sales in Values. Compact Form nests the salesperson labels below regions in a shared label column. Tabular Form displays Region, Salesperson, and Sum of Sales in separate columns. If the same region has several salespeople, the region name may appear once followed by blank-looking cells, depending on the label setting. Repeat All Item Labels fills those cells with the region name.
To change which fields are in Rows, open the field list if it is not visible: click inside the PivotTable and use PivotTable Analyze > Field List. Drag a field between the Rows, Columns, Values, and Filters areas. A text category generally belongs in Rows or Columns; a number you want summarized generally belongs in Values. Excel can sometimes place fields automatically, so check the areas rather than assuming the field landed where you intended.
Tabular Form, Outline Form, and Compact Form
Excel’s report layouts suit different purposes. Choose based on how people will read or reuse the report, not just on which view looks widest.
- Compact Form: Keeps row fields together in one column and indents nested items. It saves horizontal space and can make a hierarchy easy to scan, but it is less convenient when you need one field per column.
- Outline Form: Shows row fields in separate columns, like Tabular Form, while emphasizing the outline structure of groups. It can be useful for reports that need visible group sections and subtotals.
- Tabular Form: Shows each row field in its own column and is often the clearest choice for a flat, table-like report. Pair it with repeated item labels if readers need every row to be self-contained.
Switch between them using Design > Report Layout. The best option depends on the audience. A compact hierarchy may be easier to browse on a narrow screen, while a tabular layout is usually easier to sort, filter, print, or copy into another analysis. None of these layouts changes the original records.
Repeat labels, subtotals, and blank-looking cells
In a grouped PivotTable, Excel may show a parent label once and leave the cells below it visually blank until the next group begins. Those blanks do not necessarily mean the underlying source records lack a region or category. In a PivotTable, the displayed label can be a group heading rather than a repeated value on every line. Choose Design > Report Layout > Repeat All Item Labels to repeat labels in the report layout.
Subtotals can also make a tabular report look less like a flat list. To change them, select Design > Subtotals and choose whether to show them at the top or bottom of each group, or not to show subtotals. The exact choices available depend on the selected layout and the PivotTable structure. Grand totals have a separate control under Design > Grand Totals. Turning off subtotals does not remove the detail rows; it removes the intermediate totals for groups.
For a report intended as a clean list, a common setup is Tabular Form, Repeat All Item Labels, and no subtotals. Keep grand totals if readers need an overall result; remove them if the report must contain only category-level records. If the PivotTable includes several row fields, check the whole report after changing these settings, since labels and totals can affect every group.
When to move a field to Columns instead
People sometimes say they want “rows next to each other” when they actually want values arranged across the page. For example, suppose a report has Region and Product and should show a separate column for each year. Put Region and Product in Rows, Sales in Values, and Year in Columns. Excel then uses the year items as column headings. Changing the report to Tabular Form would not create those year columns; the field must be placed in the Columns area.
Use the field list to make this change: drag the field from Rows to Columns, or from another area into Columns. The result depends on the field’s distinct items, filters, and the PivotTable’s other fields. A field with many unique items can create a very wide report, so consider whether horizontal categories will remain readable and printable. If the goal is simply to have Region and Product in separate left-hand columns, leave both in Rows and choose Tabular Form instead.
Common problems and practical fixes
- The layout command is missing: Click inside the PivotTable first. The Design tab is contextual and is not shown as a PivotTable tab when a normal worksheet cell is selected.
- Row labels still appear blank on some lines: Choose Repeat All Item Labels. Also check whether the blank is a genuine blank category in the source data rather than a suppressed repeated label.
- The table has unexpected totals: Review Design > Subtotals and Design > Grand Totals. A group subtotal is different from the overall grand total.
- A field appears as a heading across the top: It is likely in the Columns area. Move it to Rows if it should be a left-side field, then choose the desired report layout.
- The source data changed but the PivotTable did not: Refresh the PivotTable using PivotTable Analyze > Refresh. A layout change does not refresh source records.
Also distinguish the PivotTable display from a flat export. A PivotTable is a summarized, interactive report. Repeating labels can make it easier to read or copy, but the cells still belong to the PivotTable and can change when you refresh, filter, or rearrange fields. If another system requires a fixed, ordinary range, copy the report and use Paste Special > Values in a separate location, then verify that the copied data has the detail and totals you need. Pasting values removes the PivotTable’s interactive behavior.
Excel for Mac and Excel for the web
The instructions above are for Microsoft 365 on Windows. In current Excel for Mac desktop versions, select the PivotTable and look for the contextual Design tab and its Report Layout menu; ribbon placement and availability can vary by build. The Windows keyboard shortcuts are not needed for this change, and Mac shortcut equivalents do not provide a more direct route than the ribbon command.
Excel for the web has a different, more compact ribbon and may not expose every desktop PivotTable layout control in the same place. If you cannot find Report Layout or Repeat All Item Labels in the web interface, open the workbook in the desktop Excel app and apply the setting there. The layout is part of the workbook, so it can then be viewed when the file is opened in supported versions. If a menu differs, check that you selected a PivotTable rather than a normal range.
Frequently Asked Questions
How do I put two PivotTable row fields in separate columns?
Select the PivotTable, then choose Design > Report Layout > Show in Tabular Form. Both fields remain in the Rows area, but Excel displays them in separate columns.
How do I repeat row labels in an Excel PivotTable?
Choose Design > Report Layout > Repeat All Item Labels. This repeats group labels in the report so that each displayed row is easier to identify on its own.
Why are some PivotTable row-label cells blank?
Excel may show a parent label once for a group rather than repeat it on every detail line. Use Repeat All Item Labels, and inspect the source data if the blanks remain because they may be actual missing values.
How do I put PivotTable categories across the top?
Drag the field that should become a heading from Rows into the Columns area of the PivotTable Fields pane. Tabular Form only separates row fields into columns; it does not move categories across the top.
Can I make the PivotTable look like a normal data table?
Tabular Form with repeated labels and subtotals turned off gives a flatter appearance. It remains a PivotTable, however, so it is still interactive and can change on refresh. Copy and paste values elsewhere if you need a static range.
Will changing the layout alter my source data?
No. Report Layout changes how the PivotTable displays its fields. It does not edit or rearrange the original source records.
Related
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
- Excel Data Validation From Another Workbook: Best Methods
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Dashboard Sample: A Practical Sales TemplateAn Excel dashboard sample is a one-page summary that turns a structured data table into a quick view…
- Excel Chart Horizontal Axis Labels: How to Set ThemIn Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, then under…
- Delete a Trendline in Excel Without Removing the ChartTo delete a trendline in Excel for Microsoft 365 on Windows, click the trendline in the chart to…
- How to Make a Graph in Google Sheets on a ComputerTo make a graph in Google Sheets on a computer, arrange your information in labeled rows or columns,…
- Power Pivot Date Table: Setup, Marking, and Best PracticesA Power Pivot date table is a dedicated table with one row for every date in the reporting…
- Can You Power Pivot Two Excel Sheets? How to Do ItYes. In Excel for Microsoft 365 on Windows, turn each sheet’s data range into an Excel table, add…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.