MS Excel. How to get around pivoting data that has blank placeholder columns?

[sonic99]

I've been asked to produce a dashboard based on a data set that looks something like the screenshot below. The dates are the column headings and there are blank and placeholder columns in between each of the sections. They are adding columns each month as they go along. I am unable to create a pivot table based on the current data set, because of the blank column headings. How can I get around this problem?

Also, any advice on pivoting the already pivoted data would be greatly appreciated.


Any help would be greatly appreciated.

https://imgur.com/a/vzvp5qL

 

[Gerald Higgins]

How can I get around this problem?

I think your options are to delete the blank columns, OR insert dummy column headers.

Also, any advice on pivoting the already pivoted data would be greatly appreciated.

Too vague.