Excel Pivot Table Columns Side by Side: How to Show

To show PivotTable categories side by side, select the PivotTable, open the PivotTable Fields pane, and drag the field you want across the top into the Columns area. If you mean that several row fields should each have their own adjacent column instead of being nested in one column, choose Design > Report Layout > Show in Tabular Form.

How PivotTable columns work

A PivotTable organizes fields from your source data into four areas: Filters, Columns, Rows, and Values. Fields in Rows create labels down the left side; fields in Columns create headings across the top; and fields in Values are summarized as numbers, such as sums or counts. Filters let you limit the report without changing its basic layout.

For example, a sales list with fields for Region, Product, Month, and Sales can use Region in Rows, Month in Columns, and Sales in Values. The result is a grid with regions down the side, months across the top, and a sales total at each intersection. Each month is displayed beside the others, rather than appearing as another row label.

“Side by side” can also mean a different layout: you may want Region and Product shown in separate columns at the left. That is a row-field display setting, not the same thing as putting a field in the Columns area. Identifying which result you want makes it easier to choose the right control.

Move a field into the Columns area

In Excel for Microsoft 365 on Windows, click a cell in the PivotTable. If the field list is hidden, use PivotTable Analyze > Field List. In the pane, drag the desired category field from the field list into Columns. You can also drag a field already in Rows into Columns if you want it to stop grouping the report vertically.

Click inside the PivotTable to display its contextual tabs.
Choose PivotTable Analyze > Field List if the pane is not visible.
Drag a field such as Month, Year, or Status into the Columns box at the bottom of the pane.
Confirm that a numeric field, such as Sales or Quantity, is in Values. If it is not, drag it there.
Check the headings and totals. Use the field’s drop-down or the PivotTable filters to hide categories you do not need.

The PivotTable updates as you move fields. A field in Columns usually creates one heading for each distinct item in the source data. If there are many unique items, the report can become very wide; consider grouping dates or filtering categories before treating the layout as finished. Excel for Mac has comparable PivotTable field areas, although tab names and their placement can vary by release. Excel for the web may present a simplified ribbon, but the underlying distinction between row, column, and value fields is the same.

Show row fields in separate columns

By default, a PivotTable in Compact Form can display several row fields as nested labels in a single column. For example, Region and Product may both appear under a heading such as Row Labels, with products indented beneath their regions. This is useful for a compact report, but it can be awkward when you want to sort, copy, or read each field independently.

To give each row field its own column, click inside the PivotTable and choose Design > Report Layout > Show in Tabular Form. Excel places each row field in a separate column. This changes the presentation of row fields; it does not move them into the column-heading area or create a cross-tab by itself.

If repeated labels are important, choose Design > Report Layout > Repeat All Item Labels. In a tabular report, this fills the parent label down the rows where Excel would otherwise leave it blank. That can make a copied report easier to understand, though repeated labels do not change the underlying grouping or calculations. Depending on the report, you may also want Design > Subtotals > Do Not Show Subtotals to reduce extra rows.

A concrete layout example

Suppose a source table has one row per transaction, with columns named Region, Product, Quarter, and Revenue. To compare quarterly revenue by region, place Region in Rows, Quarter in Columns, and Revenue in Values. Excel summarizes Revenue for each Region-and-Quarter combination, so Q1, Q2, Q3, and Q4 appear as adjacent headings where those values exist in the source.

To see each product as well, add Product to Rows beneath Region. In Compact Form, the two labels may be nested in one column. Use Show in Tabular Form to display Region and Product in separate columns. The quarters remain across the top because Quarter is still in Columns. This illustrates how the two layout choices can be combined: the Columns area controls the cross-tab headings, while Report Layout controls how row fields appear at the left.

If you instead want Revenue and Units Sold as neighboring measures, add both numeric fields to Values. Excel commonly displays multiple value fields as adjacent measure columns within the PivotTable. If the values appear as stacked row labels, locate the special Values field in the layout areas and move it from Rows to Columns. The exact arrangement depends on any other fields already placed in Columns.

When columns are missing or look wrong

The field is still listed down the left: It is probably in Rows, not Columns. Move it in the field list; changing the report layout to Tabular Form will not turn a row field into a column field.
Only one heading appears: Check the source data for distinct values in that field and clear any filter that excludes the others. A field with one visible item can only produce one visible category.
The column area is extremely wide: The selected field may contain many unique entries, such as individual dates or transaction IDs. Use a broader field, filter items, or group dates into a useful period where Excel offers date grouping.
A value appears as Count instead of Sum: Excel may be treating the source values as text, or the field may contain blanks or nonnumeric entries. Select a value in the PivotTable, choose Value Field Settings, and review the summary calculation. Correct the source data if a sum is intended.
New categories do not appear: Refresh the PivotTable using PivotTable Analyze > Refresh, or right-click inside it and choose Refresh. If new source rows fall outside the PivotTable’s source range, expand the source or use an Excel Table as the source so added rows are included more reliably.
Labels are blank in some rows: A compact or tabular layout may suppress repeated labels. Choose Repeat All Item Labels when you need the parent label visible on each detail row.

Also check whether the PivotTable has a report filter, slicer, or column-field filter applied. A field can be correctly placed and still show only a subset of its categories. When you change the source data, refresh the PivotTable; refreshing updates its cache and displayed results, but it does not repair incorrect source values or a source range that excludes the new records.

Choose a layout that fits the report

Use the Columns area when the purpose is comparison across categories: months across a year, regions across a product type, or statuses across teams. This arrangement is especially useful when readers need to compare values horizontally. Keep the number of distinct column items manageable, because dozens or hundreds of headings make scanning and printing difficult.

Use Tabular Form when row fields need separate labels, particularly for a report that will be read as a list or copied for further analysis. Compact Form saves space and makes parent-child grouping clear, while Outline Form provides another hierarchical presentation. Find these options under Design > Report Layout. They change how row labels are displayed, not the source data or the underlying summary.

Before sharing a PivotTable, check that its headings explain the measures and time periods, that subtotals are appropriate, and that filters are visible or clearly documented. If users need a fixed, plain data range rather than an interactive summary, a PivotTable may not be the best final format; a copied and pasted values-only report or a carefully designed table may be more suitable.

PivotTable versus a regular table

A PivotTable is designed to rearrange and summarize data without writing formulas for every group. Moving a field between Rows and Columns changes the view of the summary, and changing the summary calculation can switch a value from Sum to Count or another available calculation. It is a strong choice for exploring categories and producing several views from the same clean source.

A normal Excel table keeps records in a flat, row-by-row structure. It is often better for editing individual records, applying row-level formulas, or maintaining a source list. It does not automatically create grouped totals across categories, although functions, formulas, and charts can be used to build summaries. Keep the source data in a simple tabular format, with one header row and one record per row, then use the PivotTable as a separate reporting view.

Frequently Asked Questions

How do I put two fields side by side in an Excel PivotTable?
For two category fields across the top, drag both fields into Columns; Excel nests their headings. For two row fields in separate left-side columns, keep them in Rows and choose Design > Report Layout > Show in Tabular Form.

How do I show months as columns in a PivotTable?
Drag the date field, or an available Month field, into Columns. If the source contains individual dates, Excel may allow you to group them by months: right-click a date item and choose Group, then select Months and any other needed period such as Years. Grouping choices depend on the source values and PivotTable type.

Why are PivotTable row labels all in one column?
That is usually Compact Form, which combines row fields into a nested label column. Choose Design > Report Layout > Show in Tabular Form to give each row field its own column.

Can I put multiple value fields side by side?
Yes. Add each measure to Values. If Excel displays the Values field as a row grouping, move the Values field to Columns in the field list. The measures then appear as neighboring columns, subject to the other fields in the layout.

How do I make a PivotTable include new columns or categories?
Refresh the PivotTable after updating its source. If the new records are outside the original source range, change the data source or use a source Excel Table that expands as rows are added. A refresh alone cannot include records the source range does not cover.

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.