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 6Unpivoting Tables

Give me a lever long enough and a fulcrum on which to place it, and I shall move the world.

Archimedes

IN THIS CHAPTER, YOU WILL

  • Learn how to identify badly structured context in tables

  • Learn the basics of Unpivot transformations, including Unpivot Columns, Unpivot Other Columns, and Unpivot Only Selected Columns

  • Apply basic Unpivot transformations to improve table context

  • Learn why it is important to remove totals when you import a source table and how to do it effectively

  • Learn how to unpivot summarized tables with 2x2 levels of hierarchy in rows and columns

  • Learn how to filter out subtotals from summarized tables

So far in this book, you have learned how to tackle a wide variety of challenges to analyze unprepared ...

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