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

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