O'Reilly logo

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition by Gil Raviv

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

IN THIS CHAPTER, YOU WILL

  • 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required