Give me a lever long enough and a fulcrum on which to place it, and I shall move the world.
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 ...