Power Query - Unstack a Uneven List into a Table 🍔🦖

[@PatrickYoung-zy5qc]

Great, great video

[@AdityaDsouza-s1r]

Sensi i have learnt from you a new skill which I will use

[@basensei8699]

so great man!

[@raulparra60]

Como siempre magnífico video. Siempre se aprende algo. Gracias por compartir

[@basensei8699]

awesome!

[@BobXu-i7v]

Super Awesome!

[@jean-claudebrunet1645]

As always great Tuto. Thanks a million

[@basensei8699]

glorious!

[@tonybatty504]

Thanks James useful as always. Not sure what the real life benefit is of distilling to a 1 or 2 step solution other than to show how great PQ is at mangling data, how expert some of your subscribers are and how much I have to learn😀😀.

[@basensei8699]

glorious thanks Tony! there's so many cool ways to solve these kind of problems i love seeing how people come up with solutions !

[@mnowako]

Magic! Thank you!

[@boissierepascal5755]

Super tuto. Thanks !

[@JngP-45]

Pretty cool..thanks..

[@nathaliedardel116]

Hey I love your videos !! =D In this case with the 5th parameter of Table.Group function, we could do the same request with two steps ;) let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], GroupBy = Table.Group(Source, {"Column1"}, {{"tbl", each List.Transform({0..3} , (x)=> try _[Column1]{x} otherwise null )}} , 0 , (s,c) => Number.From(Value.Is(c[Column1] ,type number)))[[tbl]], FromRows = Table.FromRows(GroupBy[tbl], {"Date","Artist", "Song","Genre"}) in FromRows

[@boissierepascal5755]

Hard level

[@boissierepascal5755]

Bonjour Nathalie, Où apprend-t-on à coder comme tu le fais ? Formation spécifique ?

[@basensei8699]

This is a incredible solution! i'm gonna give it a go!

[@themolestones]

great

[@williamarthur4801]

As others have been adding suggestions, well this is not really necessaary but rather than adding extra column transform the Index ; Table.ReplaceValue( add_dex, (a)=> a [Column1] , (b)=> b [Index] , (x,y,z)=> if Value.Type(y) = type number then z else null , {"Index"} )

[@basensei8699]

this is glorious! basically one step! Magick!

[@williamarthur4801]

Looking forward to watching this properly again tomorrow, time for bed.

[@basensei8699]

glorious!

[@BillSzysz1]

Nice 👍 but one step solution is also possible. let Source = Table.Combine( Table.Group( Excel.CurrentWorkbook(){[Name = "Table2"]}[Content], {"Column1"}, { { "tbls", each Table.FromRows( {List.FirstN(_[Column1] & List.Repeat({null}, 3), 4)}, {"Date", "Artist", "Song", "Genre"} ), type table } }, 0, (a, i) => Number.From(i[Column1] is number) )[tbls] ) in Source

[@basensei8699]

wowsers! i love this one! 1 step ! Mind blown! i need to make a video on this one!

[@BillSzysz1]

@@basensei8699 thanks 😁

[@Krisjah]

let A = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], B = Table.Combine( Table.Group(A, "Column1", {"All", each Table.FromList( {[Column1]} , each _, {"Date","Artist","Song","Genre"} ) },0,(x,y)=> Number.From( y is number))[All]) in B

[@Krisjah]

Using fifth parameter of table group

[@basensei8699]

dammit this is glorious! in one step!

[@aasavtamboli7919]

@Krisjah Sir can you please suggest resources to learn power query for beginners as well as M language