Pivot Column in Power Query error free for Excel & Power BI
Despite spending hundreds of hours on Power Query, Pivot Columns had always been one of the few ribbon actions that I didn't understand. I would get confused about which order to do things in and how and why errors often appear without knowing how to fix them.
Example files can be found here: www.xlconsulting-asia.com/youtube-files
Upon researching it more, I figured out two methods which work for different scenarios, one with no code and one with low code. I cover lots of scenarios and recreate the most common errors so I work out how to fix those errors. If you want the exercise workbook I used please email me at [email protected]
Links:
Pivot tables for beginners: • Confused by Pivot Tables in Excel? Wa...
TEXTJOINIF: • TEXTJOIN with IF for the names from a...
Clean text with Fuzzy cluster column: • Clean up similar text in Excel with P...
Contents:
0:00 Demo
2:08 Pivot column errors
2:44 Pivot numbers (sum, average, median etc.)
3:25 Pivot columns with cycle sort order
5:37 Pivot two columns in any sort order
9:01 Pivot one column (combines other methods)
10:49 Multiple columns
12:02 A deep dataset