Pivot Table with 2 Headers Rows in Source Data

[HansrajR]

I have table with 2 header rows as follows:



I need to produce a Pivot Table as follows:



Can someone kindly help.

 

[AlanSidman]

You will need to normalize your data to be in a state where a pivot table can be created. This means unpivoting your data so that the dates are not horizontal but vertical. If you are using XL2010 or later, I would urge you to see how this is done in Power Query so that you can create a table. Firstly, you will need to eliminate all columns you do not need in the Pivot Table and then unpivot your date data. Here is a link on how to unpivot in Power Query.

 

[HansrajR]

Thanks. Works perfectly.