Power Query - Unstack Double Barrel Header Dataset

In this video i show you an alternative approach to deal with Double barrel header datasets using various list / record and table functions.
#data #dataquerying #powerquery #excel #dataanalysis #powerbi

Example file
https://github.com/jbotes/powerbiTutorials/blob/main/PQ_DOUBLE_BARREL_2_Video.xlsx

Functions used
Table.Skip
List.RemoveNulls
List.Distinct
Record.ToList
Table.ToColumns
List.Transform
Table.FromColumnns
Table.AddIndexColumn

Скачать видео