• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table with 2 Headers Rows in Source Data

AlanSidman

Well-Known Member
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.

 
Top