Fix a Missing PivotTable Column When Combining Excel Tables
Question details
The user needs to restore a column that is missing from the PivotTable Fields list after combining two 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.
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.
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.
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.
Select the full range, including its headers and all relevant rows, rather than selecting only one of the original tables.
Choose Insert > PivotTable, confirm the selected range under Table/Range, and choose where to place the PivotTable.
In PivotTable Fields, find Channel and drag it to Rows, Columns, Filters, or Values as needed.

Check the Data Model and Refresh the PivotTable
Use this approach if the PivotTable relies on related tables or a Power Query result.
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.

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.




