• 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

HansrajR

Member
I have table with 2 header rows as follows:

76459

I need to produce a Pivot Table as follows:

76460

Can someone kindly help.
 

Attachments

  • Gantt Chart.xlsx
    41.8 KB · Views: 5
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.

 
Back
Top