Excel Magic Trick 1223


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

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply