CHAPTER 7Advanced Unpivoting and Pivoting of Tables

Some painters transform the sun into a yellow spot, others transform a yellow spot into the sun.

Pablo Picasso


  • Learn how to unpivot summarized tables with 3×3 levels of hierarchies and generalize the transformation steps to unpivot any summarized table

  • Learn how to convert the unpivot sequence into a function and apply it on multiple files from a folder and multiple worksheets that require unpivoting

  • Learn how to apply Pivot to reverse Unpivot and how to apply Pivot to transform multiline records into fact tables

In this chapter, you will continue learning about the Unpivot transformation by generalizing a solution that will help you unpivot any summarized table, ...

Get Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.