Excel Magic Trick 1210


Power Query to Combine 4 Columns into 1 Table For PivotTable Report

DESCRIPTION

See how to:
(00:10) Problem Setup
(01:40) Delete Empty Columns
(01:55) Create and Name Excel Tables
(02:37) Import into Power Query and UnPivot Table
(03:28) Load Power Query Table to Excel
(04:04) Create PivotTables for Cross Tabulated Count of Year and Errors
(05:02) Create % of Column Total “Show Values As” PivotTable calculation to show Error Rates
(05:27) Change Data in Excel Table and Update Power Query and PivotTables
(07:00) Add new Year Field (Column) to Excel Table and Update Power Query and PivotTables

WORKBOOKS




Be the first to comment

Leave a Reply