APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query

#excel #exceltutorial #powerquery #m_code
---------------------------------------------------------------------
Visit the website: www.aaa-power.net
---------------------------------------------------------------------
Chapters:
0:00 Intro
0:49 Example Overview
1:47 Solution: M-Code Functions (List.Split - List.Zip - Table.FromColumns)
8:42 Solution: Worksheet Functions (WRAPROWS - VSTACK)
11:40 Close
---------------------------------------------------------------------
To watch the full Playlist
• Advanced Power Query
---------------------------------------------------------------------
To download the working files:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef

[@stephenbui490]

I'm in Progress. :D love it

[@aaaexcelenglish]

Great 👍

[@MrFredy65]

Congratulations on your great work!!!....👍From Colombia...

[@aaaexcelenglish]

Salute to Colombian colleagues, your most welcome 🙏

[@Bhavik_Khatri]

Awesome video

[@aaaexcelenglish]

Thank you 🙏

[@ramruttunaubeeluck9235]

Awesome

[@aaaexcelenglish]

Thank you 🙏

[@boissierepascal5755]

Superb and magic ! Once again. Thanks from France 🇨🇵

[@aaaexcelenglish]

Thank you 🙏, cheers from Egypt 🇪🇬

[@eduardomunoz2764]

Great, thanks and greetings from Mexico.

[@aaaexcelenglish]

My pleasure, happy to hear from Mexican colleagues, greetings from Egypt 🇪🇬

[@rangs1966]

sir table from Rows function will also bring the same result

[@aaaexcelenglish]

Absolutely correct, it saves one step compared to my solution 👍
Thank you