Pivot Table Issues

Fix a Missing PivotTable Column When Combining Excel Tables

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

The user needs to restore a column that is missing from the PivotTable Fields list after combining two tables.

Fix a Missing PivotTable Column When Combining Excel Tables
Product
Microsoft Excel
Device & OS
not provided
Scenario
Two tables are combined as the source for a PivotTable, and the user wants to add the Channel column to the report.
Observed behavior
The Channel column does not appear in the PivotTable Fields list.
Before you start

Check both source tables for the Channel header and identify how they were combined, such as through Power Query or the Data Model. Confirm that the source data has clear, unique column headers.

Solution 1Recommended

Rebuild the PivotTable from a Combined Range

Use this approach when the combined source can be represented as one flat range; using a range restored the Channel field in the reported case.

1
Prepare the combined data

On a worksheet, create or locate a single range containing the records and columns needed from both tables. Make sure Channel is included in the header row.

2
Select the range

Select the full range, including its headers and all relevant rows, rather than selecting only one of the original tables.

3
Create a new PivotTable

Choose Insert > PivotTable, confirm the selected range under Table/Range, and choose where to place the PivotTable.

4
Add the missing field

In PivotTable Fields, find Channel and drag it to Rows, Columns, Filters, or Values as needed.

Rebuild the PivotTable from a Combined Range
Check the combined range: A flat range must already contain the data you need from both tables. Rebuilding from a range does not automatically recreate Data Model relationships.
Free Microsoft Office alternative

Create PivotTables from Combined Data in WPS Spreadsheet

WPS Office is a free, lightweight alternative for working with spreadsheet data in a familiar interface. Open compatible Excel files and create a PivotTable from a prepared combined range; it does not repair an Excel Data Model.

Create PivotTables to summarize a combined worksheet range.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface for an easier transition from Excel.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why is Channel missing from my PivotTable Fields list?

Channel may be absent from the selected source, removed or renamed in a Power Query step, or hidden in the Data Model. Check the source headers and expand the available tables in PivotTable Fields.

Will refreshing the PivotTable restore a missing column?

Choose Data > Refresh All after correcting the source or query. Refreshing can load the corrected data, but it will not restore a column that is still excluded from the source.

What should I check when two tables are related?

Go to Data > Relationships and verify that the matching fields connect the intended tables. The key on the lookup side should contain unique values, and the matching fields should have compatible data.

Can I use a range instead of related tables?

Yes. If you can prepare one range containing the required records and columns, select it and choose Insert > PivotTable. The range must already include the combined data; it will not recreate relationships automatically.