Pivot Table - can't create as headers are repeated from Row 1

TheRedCardinal

Board Regular
Joined
Jul 11, 2019
Messages
197
My spreadsheet is a list of transactions for the year. I have used the print headers function to have the same column headers on the top of each page.

One of the columns in a numerical indicator of the month, and each time this changes, I have a pivot table summarising that month's data.

This means the data range is broken at the end of each month.

When I come to create the pivot table for P2, I have no column headers any more (i.e. they are visibly there, but only because they are copied from row 1).

Am I right there is no way to "persuade" Excel to use the headers from row 1 in the other pivot tables?

My current solution would be to have an actual row header on each change in month which is hidden so that it doesn't print twice - but seems inefficient?

Thanks!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,181,633
Messages
5,931,098
Members
436,775
Latest member
Taproot007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top