Excel Magic Trick 1223

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data


Learn how to create a Proper Data Set from non-normalized data (like a cross tabulated table that does not have the correct field names) using the Unpivot Columns feature in Power Query:
(00:11) Problem Setup
(01:18) Grade Data Table Example
(03:29) Sales Table Example
(04:23) Create 3 PivotTables


Be the first to comment

Leave a Reply