Power Query - Stacking Horizontal datasets 💀🦙

[@Mahmoudalgindy]

I can tell you simply : Power Query is the tool that changed my life

[@basensei8699]

it's just so awesome!

[@kevinmc2000YT]

Thanks for sharing so much knowledge! It is quite impressive the way power query flows through your mind!

[@basensei8699]

glorious thank you Kevin!

[@tonybatty504]

Another good example James to make us think.

[@basensei8699]

glorious!

[@IvanCortinas_ES]

Absolutely creative. As always, Power Query is a crazy thing...Thanks!!

[@basensei8699]

Thanks for watching!

[@williamarthur4801]

As last week, saving this till tomorrow, looking forward to it.

[@basensei8699]

thanks William! so awesome!

[@Bhavik_Khatri]

This is truly exceptional.

[@basensei8699]

glorious!

[@kebincui]

Brilliant as always. Thanks James 👍👍❤❤

[@basensei8699]

glorious thank you man!

[@boissierepascal5755]

It's always great to follow you

[@basensei8699]

glorious thank you!

[@JannievanderWalt]

Love your content dude!!

[@basensei8699]

awesome and thank you Jannie!

[@mnowako]

Amazing! Thank you!

[@basensei8699]

Thank you too!

[@SamehRSameh]

We need more about formula such as table.fromcolumn , table.tocolumn and etc ...

[@alexbarbucristi]

great skills and creativity! what would have happened if, instead of adding a custom column, the list of lists would have been transformed into a table with nested lists and that expanded into a table, promoted the headers and then filter out the empty rows and the intermediate headers?

[@basensei8699]

i think that might also work!

[@PatrickYoung-zy5qc]

Another superlative edition

[@williamarthur4801]

Really inspiring as usual, I use list select so; List.Select( List.Transform( Custom1, (x)=> List.RemoveNulls(x)), (y)=> not List.IsEmpty(y) ) and then List.Transform( List.Split( Custom2, 3 ), (x)=> Table.PromoteHeaders( Table.FromColumns( x )) ) I known the page size isn't dynamic.

[@basensei8699]

this is so awesome! i'm gonna make a video using this technique! mind blown!