How To Combine Excel Tables And Worksheets With Power Query

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
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:
www.excelcampus.com/powerquer...
Additional Videos & Resources:
Excel Tables for Beginners: • Excel Tables Tutorial:...
Power Query Overview: • How To Automate Data T...
How to Install Power Query:www.excelcampus.com/install-p...
Introduction to Pivot Tables & Dashboards Video Series: • How to Create a Dashbo...
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.
excelcampus.com/blueprint-web...
00:00 Introduction
01:58 Power Query Setup
06:58 Updating and Refreshing Data

[@gailmckee9474]

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

[@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

[@michelrail]

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

[@ryanjohnson1327]

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

[@patrickkelley9057]

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.

[@rafaelperroni8212]

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

[@loisscott3932]

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.

[@ExcelCampus]

Awesome, thank you Lois! 😀

[@noumanali4847]

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

[@wayneedmondson1065]

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!!

[@recildabrown3153]

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!

[@fluffyhoneytina]

I was having so much trouble trying to do this merge and you are the only one that explained it and I got it.....no body every mentioned that the data needed to be in a table..no wonder it wouldn't work for me...YOU are the only one that included this information.

[@khumbulanisikhosana1347]

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

[@mouldydonut123]

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

[@stephanieberget7102]

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.

[@whiplashpaint]

FINALLY!! An effective and simple way to make the Master List!! THANK YOU 😁😁 Very easy to follow.

[@RickWilliamsPlus]

Thanks Jon! I'd explored this myself, but didn't get why I had to double the sizeof the workbook by having the linked tables back in new tabs! With the tip on Create Connection Only you've got me past that hurdle! Thank you!

[@ExcelCampus]

Thanks Rick! I'm happy to hear it. Yes, this is one of those somewhat hidden features of Power Query. It's one of those things that makes sense once you understand it, but the terminology and workflow of PQ could be improved IMO.

[@scottgaines2677]

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

[@yulpereira3881]

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

[@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!

[@Men_dude]

Hey Jon, Thank you so much, the information was very helpful and am now able to use the power query in less than 2 minutes. good communication skills.

[@anamariaanyana9552]

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

[@rickcoleman]

Thank you, this has saved me a lot of time. You've made my job a lot easier.

[@cli3817]

Very clear and quick demonstration of power query which helped me understand this tool better.

[@babakdogaheh7560]

I don't know how to say my extremely appreciation for your video . Man, you are really next level . Thanks a million .

[@ExcelCampus]

So nice of you, Babak! 😀

[@Whatisupbesties]

Thank you so much for these videos you made available and at the reach of everyone who is willing to learn or forced to learn some tools to perform the work as required. My question is if we have different tables with different headers and we need to run a report or pivot table, how can we go with this? Thanks

[@emadrizkalla159]

The most easy explanation i found, thank you so much great work and i subscribed immediately so i do not miss any of your videos in the future

[@kalkwok483]

Clearly presented and very helpful! Thank you.

[@AndreaUK1973]

Ow boy! I so love PQ! Loads!! I wish I could work only with this all day long! It makes my brain gain !! And I Loved your tutorial! I’ll stick around for more Loves Gain !! Thank you lovely! You’re such a star!

[@doreentetteh869]

Thank you so much, this was very helpful and thorough. Saved me a ton of time!

[@meBuck76]

Great video. I took Mynda Treacy's course on Power Query so I knew the basics. This is powerful! Thanks. Really looking forward to your promised video on developing a macro to automate creating table connections in PQ.

[@ExcelCampus]

Thanks Mark! I'm working on that video. You can download the file that contains the macro now on the blog post. www.excelcampus.com/powerquery/power-query-combine-tables/ There is a download in the section that explains the macro. I hope that helps. Thanks again and have a nice day! 🙂

[@tabban21]

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

[@maxthepiguy3658]

This is how you teach something. Excellent video!!! Thank you!

[@Kiranck1]

Hi Jon thanks 🥰 for sharing your valuable informations to everyone.i really happy after watching this video. you have saved lots of hours from my daily work.god bless you Jon ❤️

[@abdul-azeezidowu9302]

Awesome ,, simply Awesome . Love your teaching style - many thanks .This is a game changer for me as i manage multiple data from different source ..

[@freshgirl604]

super easy to follow and was able to accomplish my task with your help! thank you !

[@mikecircelli9105]

The man, The myth, The Legend, Thank you

[@solobi2010]

THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL

[@user-tm1eq8rz5s]

thank you very much. this is the clearest video I have watched about power query!!

[@erwinvanrheenen3276]

Thanks for the clear and good explanation. You're the best! Best regards, Erwin

[@patrickquinlan5292]

I truly appreciate this instructional explanation. Extremely well done! Thank you!

[@ExcelCampus]

Glad you liked it! 😀

[@johnsolis6255]

Thank you so much, this really helped me out on an ongoing project I am completing at work!

[@michellguzelgul4267]

This is the perfect kind of content. Straight to the point, clear and concise, no added nonsense. Thank you tremendously.

[@ExcelCampus]

Thanks for the feedback Michell! 😀

[@Jenicek25]

Thanks for clear explanation! It's very helpful!

[@deepanadhitya6455]

Thank you very much for this video Jon. It is very helpful and insightful !!!!! 🙂

[@taniavincent8455]

Extremely helpful thanks! answered all my questions! All the other tutorials i could find were for Windows 16 which I dont have.

[@InsightfulJourney123]

Thank you! Amazing teaching!

[@franciscojrlarita441]

Thanks a lot. This video makes my job quicker. then Good Job for you too!

[@JohnOvens]

Excellent - great tips. Thanks Jon

[@rubychua1283]

Thank you. I find your explanation very clear.

[@shraddharangari]

Thanks helped me a lot looking forward for a macro

[@darrylmorgan]

Wicked Tutorial!Power Query Is Simply Awesome..Thank You Jon :)

[@ExcelCampus]

Thanks so much, Darryl! 🙌 I agree with PQ's awesomeness!

[@nischithp8378]

Thank you so much, using this now I can easily manage my projects

[@conorjordan19]

Hey Jon! Your communication skills are definitely on a high level. You didn't drag on or move to quickly but were able to still make your points. I do have one question. I've been googling and researching and all kinds of things to be able to pull in data from sold ebay listings to an excel spreadsheet for a price guide for my card collection. Is there any advice or help on that you could give me? Again great work

[@reyesduran79]

You can see if they have APIs available. They just started a new section called "My Collection" or something like that. It keeps track of your collection and current value.

[@PrairieDogster]

Thank you, very clear & to the point. I am now subscribed.

[@Vinay6]

You rock! I learned an awesome technique in just 12 minutes :) Thank you so much!

[@ExcelCampus]

Happy to help, Vinay! 😀

[@jessietaber2179]

I have to master this. Determined. Simplify my task of auditing my data

[@rrrpandey]

Very nicely describe , Easily understandable Thank you Very Much

[@hectorrapirap663]

Thank you. Verry nice presentation of merging sheets.

[@sisteradmn]

perfect - got it right the first time - THANK YOU

[@EdsonNascimentoEN]

Great tutorial thanks Jon.

[@sherryizzie5309]

Great tips. Looking forwards for the separate video regarding the Macro:):

[@ExcelCampus]

Thanks for the vote Sherry! It will be out soon.

[@paulhartline7886]

@@ExcelCampus did it come out yet? I couldn't find it! Thanks!

[@TalorTikva]

@@ExcelCampus Looking forward for it aswell

[@Ursula_33]

Simply outstanding teaching. Clear, concise and extremely helpful

[@ExcelCampus]

Thanks, Ursula! 😀

[@AutoDFensa]

This tutorial is exceptionally helpful, perfectly explained, and well-produced -- fantastic work, thanks!

[@ExcelCampus]

Glad it was helpful, @AutoDFensa ! 😀

[@NestorAdrianzen]

Awesome! Keep it up, Jon!

[@lucyanamamat3666]

Helps a lot of my job...I would like to know more about this Power Query

[@wissamaljuburi]

Hi Jon, awesome video man! Very useful!

[@robinrogers7949]

Thank You!! Great video tutorial.

[@bhekinkosi419]

Struggled with this for months thank you

[@diegochavezsoria]

That was awesome! Thank you so much!

[@Brwaa]

thanks so much Jon,its great lesson God bless you

[@nonoobott8602]

This is so helpful, thanks so much

[@seamushand8439]

Very well explained. Thank you

[@funese102]

Thank you so much, the tutorial is awesome

[@jaliali84]

Awesome, simple and powerful

[@krynauwkrowd8560]

Thank you your videos are amazing.

[@andrearagao5489]

Super useful! Thank you

[@mithunnv5628]

U r doing great job here....thanks lot...easy to understand .

[@sonnybr4711]

Thank you for saving my day!

[@katherinealindogan-tagudin7065]

Such a big help :) Thank you.

[@nikhilmay2]

Thanks a ton... this video helped me a lot!!!!

[@JigarPatel-lj5pv]

Thanks a bunch Jon. excellent video and very well explained.

[@ExcelCampus]

Glad you liked it! 😀

[@michaelbelow1415]

This is a very clean and smooth process in power query and demonstrated very clearly! One question--If I have mult spreadsheets saved out in a share drive folder can I still attain this combined approach into one table or do the table need to exist within one workbook?

[@vikramraghuwanshi9455]

HOw beautifully you each this topic . , its really appriciates.

[@rubenaugustine8666]

Thank you so much for this video.

[@tonic4834]

Great tutorial!

[@aviroy7085]

It's a magic Jon !! Thank you for the video. Can you please share the video link for "connection of sheets" with the help of Macro

[@vsnduos217]

Perfect, thanks a lot!

[@amberjen2749]

Thanks Jon! Your video tutorial are great. I'm fairly new to Power Query and currently practicing this great tool. In your sample how would you have Power Query turn the cell in "Category" header to column? For example: Candy column, Fruit & Veg column, Beverage.... I hope you can do a video on this. THanks.

[@luisfernandocuestasanchez4343]

God bless you man ¡¡ you are our saviour

[@michaelcward1]

Thanks Jon, this is by far the best video out there! Question, if I want to create a master sheet with prices to populate into other sheets in the same excel document, how do I go about it?

[@tomdarling-fernley3178]

Brilliant tool, brilliant tutorials. Thank you! How do you deal with really nasty Excel sheets? Example: a team updates a single worksheet with weekly figures for one year in a range above or below a range of equivalent figures for another year, and you need your query to interrogate both ranges (which are not tables). How does EPQ assimilate a new 'sheet row' of weeklies added in between the ranges?

[@ferreiraferreira7392]

top tutorial. thanks!

[@robertjcliu]

It is helpful. Thank you.

[@johnharker3478]

Thank you, simple and easy to follow along

[@ExcelCampus]

Thanks for the feedback, Jon! 😀

[@rithysrey2582]

Hi, John! that is awesome video, appreciated if you share the Macro to combine all tables. thank you

[@gabrielacattaneo7412]

Thank you so much.. I was searching for such a good video for hours! You really helped me. 😀

[@ExcelCampus]

You're welcome! 😀

[@22punkpirate]

Thank you!

[@hobber_]

for the algo, this was just what I needed, thx!

[@ExcelCampus]

Awesome, thanks for watching!

[@gajanandhumal8883]

Thank you very much.

[@LaraTraveling]

Fantastic!