Download Files:
Start File: excelisfun.net/files/1338Star...
Finish File: excelisfun.net/files/1338Fini...
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
Негізгі бет Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set
Пікірлер: 59