Power Query - Unstack a Uneven List into a Table 🍔🦖
In this video i show you how to take a list of Songs with the artist name genre and release year and unstack it into a table taking into consideration that not all songs have genres allocated to them. #dataanalysis #excel #exceltips #powerqueryeditor #powerquery #mquery #powerbi 🦒
Following along file
https://github.com/jbotes/powerbiTuto...
Functions used
• Table.addindexcolumn to add index
• Value.Is to identify if a field is a number
• Table.AddColumn to add new colums
• Table.FillDown to fill down the key values
• Table.Group to group per song
• List.Transform to trasnform a list
• Table.FromRows to created a table from a list
• Table.Combine to stack tables ontop of each other
• Table.ToRows to create List Value pairs for column renaming
• Table.RenameColumn to rename the columns