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
Also, any advice on pivoting the already pivoted data would be greatly appreciated.
Any help would be greatly appreciated.
https://imgur.com/a/vzvp5qL
Last edited: