APQ04: Advanced Power Query Video #4 - M-CODE - Combine Inconsistent Tables

Chapters:
--------------------------------------------------------------------------------------
0:00 Intro
1:30 Combine Multiple Tables in one Workbook
5:24 Extract a Dynamic List of Column Headers
10:37 Dynamically Expand Columns
15:07 Closing
--------------------------------------------------------------------------------------
To watch the full playlist
--------------------------------------------------------------------------------------
To download the working files:
--------------------------------------------------------------------------------------
To subscribe:
--------------------------------------------------------------------------------------
To follow on Facebook
--------------------------------------------------------------------------------------
To follow on LinkedIn:

[manjeetmarothiya]

Dear Sir please make video on power BI in English Also...

[hamvasq]

All great videos! Thank you very much.

[aniljaggarwal]

You are sacrificing all the knowledgeable treasure of Excel on the world, in return you will get the love and respect of the world.

[Hurmali]

This is excellent, i need to re-visit it a few more times however thank you sir

[agostinhosubtil]

Another spectacular lesson. Thank you very much for spreading relevant knowledge.

[kuyakambo]

You've explained it far more clearly than the tutorial I've got from Online Courses. Thank you for this awesome video.!!

[michaelaltshuler]

Nice job explaining all the details; big help.
One issue I am having is when I do the Transform of the data file in addition to the the sheets of the source wokbook, I see a bunch of ExternalData tables which are marked "Hidden". This results in a bunch of undesired rows in my appended worksheet. Where did thes ExternalData sheets come from, and how can I get rid of them?
Thank you very much.

[mahmoudmhamid]

يعطيك العافيه استاذ
أنا بشتغل محاسب تكاليف بمطعم و جردت اخر السنه و عملت تسوية جردية للمستودع عشان اثبت الفعلي عملت تسوية مدينه و تسويه دائنه
الفعلي طرحت منه المعياري و بعدها خرجت الموجب و أدخلت السالب ع المستودع عشان ما يطلع فرق و فعليا المستودع صار الفروقات فيه صفر لكن ع ميزان المراجعه حساب المخزون كبيرررر يعني ضعف بضاعه اخر المده شو السبب؟

[stephenbui]

I've learning M code by coding :D

[Mohamed-kmjd]

What if i don't want any null value in new column?

[ozGold]

Excellent video! Keep up the great work.

[amanijeanpierre]

How do I export data with file name using power query for text files.

[israfilgazi]

It really helps me . JAZAKALLAH KHAIR. Thanks a lot.🧡🧡🧡

[mathsexperts]

This channel is the best one I have seen in YouTube, Excellent content, Great work

[zahoorsarbandi]

wonderful!.. such issues are usually faced in appending. this video is a complete solution to it.

[kebincui]

Wonderful video, keep it up and thank you for sharing💌

[manjeetmarothiya]

Thank you so much sir, You explain the List very very Awesome, its so much easy. Thanks for this video. One again sir Thanks.. ❤️❤️