How To Combine Excel Tables And Worksheets With Power Query

In this video, I explain how to combine multiple Excel Tables or Worksheets with Power Query. You will learn how to fully automate this process to save you a ton of time with this common Excel task.

The video covers:
The prerequisites for the data and column structure.
How to setup the connection queries in Power Query, plus a macro to make this faster.
How to append or combine the queries to stack the data.
The update and refresh process when the data changes or you get new data.
How to add new tables to the append query.

You can download the example file on the following page:

Additional Videos & Resources:

Free Webinar on The Modern Excel Power Tools:

If you are new to Power Query and/or not sure how it fits into other features like Power Pivot, Power BI, pivot tables, or macros & VBA, then check out my free training webinar. It’s called the Modern Excel Blueprint and it’s running right now for a limited time.

00:00 Introduction
01:58 Power Query Setup
06:58 Updating and Refreshing Data

[SuperZlatorog]

Thank you so much!!! I've consulted with so many people in my organization, and no one seems to know how to append tables using power query. Thank you!!! Bookmarked because I'll use this all the time! :D

[gailmckee]

Jon, your work is fantastic. I can't believe how much easier this makes my job. Thank you, I have learned so much!

[khumbulanisikhosana]

Thank you so much this helps a lot...copying and pasting was so tiring and boring

[ryanjohnson]

Love your teaching style! You make a difficult task so much easier. thx!

[rafaelperroni]

Man, amazing... amazing teaching technique, non-arrogant communication and world class up-to-speed pace. Well done.

[scottgaines]

Another great video! Very straightforward and easy to follow. Thanks Jon!

[patrickkelley]

Great tutorial. Very clear instructions. I only wish I had found your videos before I began working on my current project. Still, this will make moving forward so much easier.

[michelrail]

Thank you, Jon, you saved me 2 hours of tedious work per week. I'm beginning to really love Power Query.

[wayneedmondson]

Hi Jon.. great video! The more I practice Power Query, the easier it gets. Thanks for the examples and practice files.. very much appreciated :)) Thumbs up!!

[noumanali]

Beautifully explained each step. Answered all my questions. exactly waht i was looking for. Thank you much.

[loisscott]

Whilst I am generally not a fan of video instructions, this one was great! Jon really explained the concepts well, each step was easy to see and understand why it was done that way. I will be using this to help with a volunteering role and likely will look up some more of Jon's videos the next time I am trying to work out how to do something in Excel! Thank you Jon.

[recildabrown]

I concur with your previous subscriber. Your communication and visual materials are definitely at a high level! Thank you so much for sharing your expertise. This information helped me much!

[mikecircelli]

The man, The myth, The Legend, Thank you

[kalkwok]

Clearly presented and very helpful! Thank you.

[yulpereira]

Thanks Jon, this is awesome, just saved a few hours per year of my life

[tabban]

This is exactly what I was looking to do! Thanks so much

[stephanieberget]

MUCH agreed on the level of communication and explanation. After watching a few other highly recommended channels I was left with many unanswered step questions. Instructors sometimes leave out small details simply because they are so use to doing them they forget how important explaining every step is. So appreciative of how you think and share information.

[anamariaanyana]

Thank you so much! This was very helpful and I CAN'T WAIT to apply it at my job! So useful!

[mouldydonut]

You've made what I thought was impossible, possible. Thanks

[djdtor]

Thank you for the tips this is exactly what I was looking for and I was able to catalogue my company's overstock items so we can efficiently push their sales. You da man!