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

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

[@mikecircelli9105]

The man, The myth, The Legend, Thank you

[@gailmckee9474]

Jon, your work is fantastic. I can't believe how much easier this makes my job. Thank you, I have learned so 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

[@michelrail]

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

[@whiplashpaint]

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

[@rafaelperroni8212]

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

[@ryanjohnson1327]

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

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

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

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

[@noumanali4847]

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

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

[@solobi2010]

THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL

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

[@scottgaines2677]

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

[@mouldydonut123]

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

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

[@cli3817]

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

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

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

[@kalkwok483]

Clearly presented and very helpful! Thank you.

[@yulpereira3881]

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

[@maxthepiguy3658]

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

[@anamariaanyana9552]

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

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

[@rickcoleman]

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

[@jessietaber2179]

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

[@patrickquinlan5292]

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

[@ExcelCampus]

Glad you liked it! 😀

[@tabban21]

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

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

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

[@doreentetteh869]

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

[@freshgirl604]

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

[@johnsolis6255]

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

[@nischithp8378]

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

[@zarniwhite6249]

Thank you! Amazing teaching!

[@Jenicek25]

Thanks for clear explanation! It's very helpful!

[@user-tm1eq8rz5s]

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

[@rrrpandey]

Very nicely describe , Easily understandable Thank you Very Much

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

[@franciscojrlarita441]

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

[@JohnOvens]

Excellent - great tips. Thanks Jon

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

[@rubychua1283]

Thank you. I find your explanation very clear.

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

[@shraddharangari]

Thanks helped me a lot looking forward for a macro

[@erwinvanrheenen3276]

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

[@Ursula_33]

Simply outstanding teaching. Clear, concise and extremely helpful

[@ExcelCampus]

Thanks, Ursula! 😀

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

[@EdsonNascimentoEN]

Great tutorial thanks Jon.

[@bhekinkosi419]

Struggled with this for months thank you

[@deepanadhitya6455]

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

[@SuzukiCentre]

Please accept my Hero Award! 🏆Just Excellent!

[@ExcelCampus]

Thank you! 😅

[@taniavincent8455]

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

[@Vinay6]

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

[@ExcelCampus]

Happy to help, Vinay! 😀

[@hectorrapirap663]

Thank you. Verry nice presentation of merging sheets.

[@jaliali84]

Awesome, simple and powerful

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

[@robinrogers7949]

Thank You!! Great video tutorial.

[@diegochavezsoria]

That was awesome! Thank you so much!

[@funese102]

Thank you so much, the tutorial is awesome

[@andrearagao5489]

Super useful! Thank you

[@seamushand8439]

Very well explained. Thank you

[@JigarPatel-lj5pv]

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

[@ExcelCampus]

Glad you liked it! 😀

[@darrylmorgan]

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

[@ExcelCampus]

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

[@PrairieDogster]

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

[@krynauwkrowd8560]

Thank you your videos are amazing.

[@rubenaugustine8666]

Thank you so much for this video.

[@vsnduos217]

Perfect, thanks a lot!

[@nonoobott8602]

This is so helpful, thanks so much

[@luisfernandocuestasanchez4343]

God bless you man ¡¡ you are our saviour

[@vikramraghuwanshi9455]

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

[@tonic4834]

Great tutorial!

[@wissamaljuburi]

Hi Jon, awesome video man! Very useful!

[@hobber_]

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

[@ExcelCampus]

Awesome, thanks for watching!

[@sonnybr4711]

Thank you for saving my day!

[@stefanogattoCH]

😆You may laugh at me, because one year ago I made a macro to do exactly the same thing! Thank you for this video!

[@ferreiraferreira7392]

top tutorial. thanks!

[@sisteradmn]

perfect - got it right the first time - THANK YOU

[@nikhilmay2]

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

[@Brwaa]

thanks so much Jon,its great lesson God bless you

[@NestorAdrianzen]

Awesome! Keep it up, Jon!

[@mithunnv5628]

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

[@katherinealindogan-tagudin7065]

Such a big help :) Thank you.

[@robertjcliu]

It is helpful. Thank you.

[@lucyanamamat3666]

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

[@AutoDFensa]

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

[@ExcelCampus]

Glad it was helpful, @AutoDFensa ! 😀

[@jabulisilemalindi9590]

Thanks this was helpful

[@gajanandhumal8883]

Thank you very much.

[@triforce1006]

Thank you! I was scratching my head for too long before I found this!

[@ExcelCampus]

Glad you found us, Triforce1006! 😀

[@22punkpirate]

Thank you!

[@johnharker3478]

Thank you, simple and easy to follow along

[@ExcelCampus]

Thanks for the feedback, Jon! 😀

[@allenlei2488]

very helpful, thx a lot

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

[@gabrielacattaneo7412]

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

[@ExcelCampus]

You're welcome! 😀

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

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

[@Henryerazo]

Wounderfull thanks for shared