Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 1

In this video you'll learn to combine data from multiple excel files into a single sheet using Power Query. In this case I am assuming that your data structure will be the same

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[francismella]

You have provided the best explanation of this process that I have found online. Precise and to the point!. Well done!!

[partibanmenon]

This was the best tutorial ever! Best explanation in a very methodical manner and straight to the point.

[alainaeemmanuel]

Just an amazing tutorial. Straight to the point. Best explanation I've seen as it covers both even and uneven data structures

[GamblingTimeKaraoke]

Several years late to the party, but still extremely helpful. Thank you for simplifying my work day!!!

[videozon]

Amazing this saved me 30 min of daily work, used to copy 15-17 files manually into a master excel for my work

[satishdhore]

thank you for this, i was searching this solution from last 3 hrs but didn't get exact solution ... n finally i m satisfied with this video

[kangsungho]

Very unique lessons found no where else!

[bharathie]

Thanks a lot and you saved my time more than 3 hours..

Keep on assisting us. All the best

[manojjrkhiara]

Superb way of explanation, thank you so much for your efforts and guidance, Goodly ji

[mebshaji]

This is amazing and well explained. Next question is how do you auto refresh the power query to avoid having to manually refresh?

[joanned]

Thanks for getting back to me on my question. Your other teaching did solve my problem. Good teaching. Keep up the good work.

[kothadurgaprasad]

You have explained in best way with all the scenarios tqq soo much sir
You made my work very easy

[zzvfkih]

Thanks a lot, its very useful, i saw others video, but yours one is details and clear info,

[sumanthbhat]

Awesome video..no junks in explanation..Thanks a lot..

[RakeshKumar-cfed]

Thank you for sharing this video this is the very helpful for combine multiple excel data into one sheet

[irishpolito]

This is very helpful. it saves me a lot of time. thank you

[DJDEEM]

You're a lifesaver bro!!! Great video.

[TheMirkis]

Thanks a lot! Just to the point - quick and clear!

[killacub]

AMAZING! THANKS WHAT A GREAT VIDEO!!!! you just saved be a whole bunch of work today and in the future!!

[sachingurav]

Hey dude thanks so much information was really helpful for me n could apply in my work as well. 2nd important thing is the way you have exlained throughtout the viseo its just awesome to understand. Thanks again keep it up. Grt efforts Regards, Sachin