Using the List technique in Power Query to recombine tables

[@ExcelOnTheRoad]

Awesome video Wyn!

[@AccessAnalytic]

Cheers Giles

[@GeertDelmulle]

Lists are the secret weapons of PQ-M! 🙂

[@Bhavik_Khatri]

Here is another excellent Wyn List presentation.

[@AccessAnalytic]

Cheers !

[@chilaw2004]

You’ve got a great teaching style, Wynn. Easy to listen to and follow.

[@AccessAnalytic]

Thank you. I appreciate the kind comment.

[@zzota]

Thanks, Wyn. I'm starting to edit my M code rather than using built-in steps, thank to your guidance. Lots of functions to remember!

[@AccessAnalytic]

That’s definitely the big challenge when you’re not using it all the time

[@huseyinburaktasci1638]

A pragmatic solution! Thanks a lot Wyn!! ☺

[@AccessAnalytic]

No worries. You’re welcome.

[@cristianprifti]

Really simple explained! Thank you also fot the Shift + shortcuts, had no idea about them :)

[@AccessAnalytic]

You’re welcome. Thanks

[@raimundojs9547]

Excellent! 💚

[@kebincui]

Super! Thanks Wyn and look forward to more videos like this 👍

[@AccessAnalytic]

Cheers

[@chrism9037]

Thanks Wyn, very useful!

[@AccessAnalytic]

No worries

[@chiragdabhi4929]

Before that we use index function this is awesome !!

[@AccessAnalytic]

We did indeed!

[@mnowako]

Excellent! Thank you!

[@AccessAnalytic]

You’re welcome.

[@sherryfox227]

Wyn, this is great!

[@AccessAnalytic]

Cheers

[@shubhabratadey]

Really cool. Thanks for sharing this

[@AccessAnalytic]

You’re welcome

[@aman_mashetty5185]

simply awesome speciall the shortcut

[@AccessAnalytic]

Cheers 😀

[@Haitham_ELtahan]

I don't have word just ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@AccessAnalytic]

Hah! Yeah this is a great technique suggested by fellow commenters . 💙DataCommunity

[@westleyempeigne6541]

That’s amazing!

[@AccessAnalytic]

Thanks for letting us know

[@vladog1834]

Briliant

[@sledgehammer-productions]

Cool!

[@williamarthur4801]

any ideas about making page size dynamic for if not all 3? re naming i took the first 3 Source ;
List.Transform( List.Split(
List.Combine( Table.ToRows( Source )), 3 ), (A)=>
Table.FromRows( {A}, List.FirstN( Table.ColumnNames( Source),3) ))

[@AccessAnalytic]

Without a column name identifier and without a consistent number of columns it would be difficult to build the logic that would be guaranteed to work in all scenarios

[@iduncanw]

Definitely some great functions, but what's scary is that something like that is needed (ie lots of really badly setup spreadsheets everywhere).

[@AccessAnalytic]

Sadly it’s normally the fault of the central system export design. Far too often export to Excel or CSV generates this sort of nonsense.

[@iduncanw]

@@AccessAnalytic true. I had a system that had an export to Excel option.... It exported the file as XML which I'm pretty sure the average user has no idea what to do with and what's more it warned you that it might be a dangerous file.

[@rizkihidayat4724]

awesome

[@AccessAnalytic]

Cheers