Combine Data From Multiple Excel Files into a Single Excel File - With Dynamic Columns and Sheets

2 Similar Videos that I made earlier

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[Lucyliuyu]

This is what I am looking for. Thank you so much for sharing! It’s awesome!!!

[SMITDEDHIA]

The best Goodly video in my opinion. Loved it! Thanks a ton!!

[michaelmontgomery]

This was very helpful, and your style was so easy to follow along. It was exactly what I needed to do with some files I received (100+). Thank you so much! And I'm a total noob with Power Query, but still got it done. Thanks!

[boovank]

This is what i am look for the Past one week . Now i find out. Thank you so much.

[DS]

Thanks a million Brother, I was struggling since last two days to understand the error from where it was coming now after watching your video it's cleared. Keep it up. 👍

[sambhattacharya]

Thanks a ton!! I liked the way you explained with crisp words

[SantiagoCorbalanH]

Excelllent video! You tuly deserve many more subscribers (11K) and views (23K) than I can see at the time of watching it. I 'm glad that I found your channel and videos. Keep them coming and know that they are much appreciated!

[vasilisa]

Very good informative video. Thank you a lot. You explain the solution in the way I can easily understand and grab the logic although I just start using power query. And yet not in a simplistic way. Perfect) I subrscribed. Can't wait to go though you other videos.

[zarad]

Thank you for this super helpful vid! So great to stumble upon someone who knows their stuff. Sub'd and can't wait to see more from you!!

[Piyush.A]

Such an under-rated video. Thanks so much!

[Alan.DL]

I LOVE IT ♥ Man, you're my savior! I have been looking for such solution for more than 6 months and I couldn't find it anywhere! I have a report coming every week with rolling 52 weeks meaning that the next week report will have one week less at the beginning but a new one at the end. The only way I could "solve it" was altering the Excel files before uploading them. This will save me a lot of time and headaches when explaining to people how to update their own reports! (Using it in Power BI but still, solved it the same!)

I will share this solution everywhere to give you the credit!

[joshhope]

Best power query video i have ever watched. It is highly appreciated that you help me a lot. Although i am using power bi for this application, it still works. Cheers man you save my week.

[thetungvu]

Your video deserves much more attention. I have a folder with more than 100 excel workbooks, it will take forever if not for your awesome video.

Keep it up man
If you can do vids about fuzzy lookup for match, even better!

[guilhermearrudasowek]

Thank you. This will be very usefull! Is gonna save me a lot of time

[tanujamane]

You've explained very well. Very helpful.

[ripudamansingh]

Tusi great ho, I have never seen any tutorial like this. Amazing & to the point

[prashantbonde]

you are expert. Thanks for sharing the knowladge.

[johnle]

Thank you for sharing your knowledge. I subscribed your channel.

[SuperDarekR]

Thank you a lot. You are my EXCEL MASTER

[maheshkulkarni]

Thank you very much. this was really helpful.