Transform a nested table to PivotTable


This post was moved here.

Comments (10)

  1. anonymouscommenter says:

    Prepare to be amazed 🙂
    This is the fourth post in the series The Definitive Guide to Unpivot with

  2. anonymouscommenter says:

    Prepare to be amazed 🙂
    This is the fourth post in the series The Definitive Guide to Unpivot with

  3. Gil Raviv says:

    As promised, here is the next post, that will show you how to unpivot any summarized table, no matter how many nested row and column headers you have:

    http://blogs.technet.com/b/gilraviv/archive/2015/10/18/transform-any-nested-tables-to-pivot-table.aspx

  4. anonymouscommenter says:

    By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (main posts

  5. Thank you for posting this series. Nice step by step with bthe solution provided 🙂

  6. khaled awad says:

    Thanks for sharing information.

  7. David Tyler says:

    Nice instructions! Thanks.

    Note that the download file has a table created on the Sales tab already (with headers of Column1, Column2, etc.). You may want to convert that to a range and strip the formatting to avoid user confusion. Then again, I suspect most people reading something
    on unpivoting data with power query would be able to figure it out…

  8. Gan Davnarrain says:

    Very helpful. Well explained.

  9. BC says:

    Thanks so much, this is really helpful 😀

Skip to main content