CHAPTER 7Advanced Unpivoting and Pivoting of Tables
Some painters transform the sun into a yellow spot, others transform a yellow spot into the sun.
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, ...