In this video post I’ll share techniques to unpivot complex cross tabulated data with nested headers and columns into a nice and clean table. Let’s go!
Unpivot Cross Tabulated Data – Video
More on Power Query
- Unpivot Data with 2 Headers
- Convert Multiple Columns in Rows
- Repeat Row N Times
- Combine Duplicate Vlookup values in a Single Row
- Rank data based on 2 conditions
Power Query Tips Playlist
.
Automate repetitive data cleaning tasks using Power Query
A comprehensive course to learn Power Query to automate all your mundane and repetitive data cleaning tasks in Excel or in Power BI
DOWNLOAD THE COURSE OUTLINE | ENROLL IN THE COURSE
