How to Combine Multiple Excel Sheets with Power Query the RIGHT WAY 🤫

Here’s the thing data is messy! So in this video I’m revealing the code that you should use when you have messy data where your headers start on different rows and you want to combine all these sheets into one.
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft

[@MissMicrosoft]

If you enjoyed this video then you should definitely watch this video next on Power Query Refresh Secrets: th-cam.com/video/kAPqr8DCOng/w-d-xo.html

[@decentmendreams]

I am sorry to hear that only 20% of your audience has subscribed. How can one resist such a beautiful instructor?

[@Gorman-84]

That was great. Thank you for explaining the intermediate steps and showing how they work.

[@MissMicrosoft]

You’re welcome ☺️

[@eslamfahmy87]

Excellent!!😊

[@MissMicrosoft]

Thank you 😊

[@n1ckyr930]

Great video, thank you 👍

[@MissMicrosoft]

You’re most welcome!

[@zahoorsarbandi2982]

Every time I learn a new PQ concept from your every lecture. A clear concept and easy explanation is compelling me to wait for your video curiously. Keep it up! Miss Microsoft

[@MissMicrosoft]

I'm so glad to hear, thank you Zahoor! 😊

[@kebincui]

Excellent👍

[@MissMicrosoft]

Thank you Kebin!

[@tapansahu6595]

New learning for me. Very well explained👌

[@MissMicrosoft]

Thank you 😊

[@dispirted8]

This is next level for me. Subscribed to learn more.

[@MissMicrosoft]

Awesome thank you for the support!

[@franzzzis]

absolutely brilliant and helpful.. clear and very good presentation

[@MissMicrosoft]

Glad you enjoyed it, thank you!!!

[@Sumanth1601]

Subscribed! Excellent content 👌

[@MissMicrosoft]

Awesome, thank you!

[@MichaelBrown-lw9kz]

This is an impressive video. I still have so much to learn when it comes to Power Query.

[@MissMicrosoft]

Thank you. You’re at the right place if you would like to learn more on Power Query :)

[@alializadeh8195]

Thanks

[@MissMicrosoft]

You're welcome!

[@amanijeanpierre7911]

Hello Miss,
Thank you for your contribution!
Do me a favour and tell me the solution to Data initialisation failed error which happens to more computers

[@MissMicrosoft]

You're most welcome! For the data initialisation failed error you may want to check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database.
This is normally related to you not having the correct data connector installed for your version of Excel. Make sure you have installed the correct (64 bit or 32 bit) data connector. Hope this helps!

[@Rice0987]

As my colleague says "Ctrl+V, Ctrl+C" (exactly in this sequence)😂

[@MissMicrosoft]

😝

[@Dansel_B]

oh my god! that was what i have been looking for throughout the internet for long time! since my M code is very poor!
i really thank you, my beautiful sis!
keep on all these useful trainings coming!
from your bro, Dansel.

[@MissMicrosoft]

Glad that the video was helpful! If I could ask that you please not use God’s name in vain, thank you 🙏

[@Dansel_B]

@@MissMicrosoft okay dear, i didn't mean to use God's name in vain at all. i never did so. however, i am sorry if it sounded that way to you.

[@MissMicrosoft]

Thank you

[@gospelmoto2833]

Thanks for the share. It helped! I would appreciate more if there's a dataset so we can follow along.

[@MissMicrosoft]

You’re most welcome! Sorry about that, I will let you know when I’ve uploaded the file.

[@djl8710]

Good

[@MissMicrosoft]

Thank you :)