Excel Magic Trick 1338

Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set

DESCRIPTION

See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set:
(00:15) Introduction
(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
(13:46) Example 2: Start with 12 Cross Tabulated Tables. See the Power Query Function: Table.UnpivotOtherColumns & Table.PromoteHeaders
(23:30) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply