Рет қаралды 2,613
In this video, Ken shows how to unpivot a complex table made of nested subtables with Power Query (for use in Excel or Power BI). Combining two Power Query recipe patterns (Unpivot Subcategorized Tables and Pivot Stacked Data), it shows just how robust a Power Query solution can be!