Solving the Query – Pivot Edition

Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation, our co-host Thomas LaRock expressed his frustration at the lack of a simple method to complete what should be a simple task in Power Query. In Tom’s example, he explained he wanted to replace a given value within the column names without individually renaming all of the columns. He pointed out that this has been possible in Office for 20+ years but requires learning some M to complete in Power Query due to the fact that column headers are not considered data. Simple frustrations like this have even led our beloved founder, Rob Collie, to make frightening statements about a possible return to Microsoft! Don’t worry, though, Allision had a very simple fix. In fact, like a moment from the game show “Name That Tune”, she stated that she could solve […]

source https://p3adaptive.com/2022/04/solving-the-query-pivot-edition/