APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets

Chapters:
--------------------------------------------------------------------------------------
Intro: 0:00
3:51 Transform Data Table
6:29 Table.FillDown
9:16 Table.Skip
11:47 Table.PromoteHeaders
13:50 Table.UnpivotOtherColumns
16:58 Get Data From Headers
18:02 Table.FirstN
19:20 Table.SelectColumns
21:00 Table.Trnaspose
25:49 Closing
--------------------------------------------------------------------------------------
To watch the full playlist
--------------------------------------------------------------------------------------
To download the working files:
--------------------------------------------------------------------------------------
To subscribe:
--------------------------------------------------------------------------------------
To follow on Facebook
--------------------------------------------------------------------------------------
To follow on LinkedIn:

[StefanoVerugi]

beautiful video, learned so much in less than 30 mins
thanks

[vacilando]

One of the best M code explanations with great sample.Thank you

[kuyakambo]

Your Channel is a hidden gem, you deserve a millions of subscribers. Your tutorial on M Code is so amazing. The way you teach is easy to follow with. You made everything looks so simple.

[kishorpanara]

Dear i am waiting for your video and thank you for video in English

[vijayarjunwadkar]

Wow, What a Video! Excellent Tutorial! I got clear on so many things about Table Functions and M in just this one! Thanks a lot, I am going to check all your other videos soon! Keep up the great work! 😊👍

[ozGold]

Excellent video. Well explained. And going at a good pace. Very good using Table functions all within one step. Also, good M code formatting to be same way as DAX.

[muhammadshahzadafzal]

Excellent again . Sir, you are simply the best!

[kennethpaige]

That was very, very good. The contrast between your explanations and others I have watch is just striking. You have a true talent for teaching. Thank you so much!

[GosCee]

Excellent teaching! Thank you very much.

[jbgolf]

Truly amazing video and explanations. Thanks for your work!

[PaúlAlexanderRivasLaBarrera]

Tus tutoriales son de mucha calidad, gracias por compartir tus conocimientos.

[FsoOmar]

رائع جدا، أسلوبا وعرضا ومعلومات.
استفدت كثيرا منك، وأعجبني تنظيمك في كتابة الكود مرتبا وموزونا. إذا كان أحمد شوقي أمير الشعراء، فحضرتك أمير الباور كويري، بجد والله.
جزاك الله خيرا ووالديك،

[aniljaggarwal]

Wonderful, Thanks for explaining difficult/complex coding programming in very simply manners

[alexrosen]

Amazing tutorial. Great pace and easy to understand language

[quadcoresprashant]

Nice video a lot to learn in most cleaner way

[israfilgazi]

How well explained to make anyone understand was Really Unbelievable to me before watching this video. ❤❤❤

[Altaf_Alam]

Your videos really help me a lot to understand the concepts... Thank u very much sir 😍

The way you teach is just tremendous 😊

[zahoorsarbandi]

Wonderful!...exactly what I was searching for... Thank you sir...

[SamehRSameh]

Magic video as usual 🥰
Please minimize space in code to see all code

[MrFredy]

Excellent a lot from hope the next!!!!....