Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set

Download Files: Start File: https://excelisfun.net/files/1338Start.xlsx Finish File: https://excelisfun.net/files/1338Finished.xlsx See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set: 1. (00:15) Introduction 2. (01:14) Example 1: Start with 12 Cross Tabulated Excel Tables (Tables set up as Official Excel Tables using Excel Table feature). See the Power Query Function: Table.UnpivotOtherColumns 3. (13:46) Example 2: Start with 12 Cross Tabulated Tables. See the Power Query Function: Table.UnpivotOtherColumns & Table.PromoteHeaders 4. (23:30) Summary