Transform ANY nested table to Pivot Table with function query

This blog post was moved here.

Comments (10)

  1. anonymouscommenter says:

    On the previous page of this tutorial, we used a function query FnUnpivotNestedTable to unpivot ANY nested

  2. anonymouscommenter says:

    Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms

  3. Vicente Castello Ferrer says:

    Hi Gil. Great article. Than ks a lot.

    I think that there’s a missing step in the article. Once you have unpivoted the other columns I think there must be a "Split column by delimiter" step. In it you turn the merged column into three columns.

    It is in the query included in the workbook, but somehow it did not appear in the written article.

  4. Gil Raviv says:

    Hi Vincente,
    Thank you for the feedback. You are correct. I added the missing step.

  5. Mynda says:

    Hi Gil,

    Great post. I think it would be better if the sample file didn’t still contain RANDBETWEEN because it makes cross referencing your query output with the input very confusing.


  6. Gil Raviv says:

    Hi Mynda,
    Thank you for reading. Following your recommendation I removed the RANDBETWEEN.

  7. anonymouscommenter says:

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

  8. Thanks for pointing out the link to create this in the PowerBI Desktop as well

  9. anonymouscommenter says:

    To Follow

Skip to main content