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

[@gailmckee9474]

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

[@michelrail]

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

[@rafaelperroni8212]

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

[@khumbulanisikhosana1347]

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

[@ryanjohnson1327]

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

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

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

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

[@whiplashpaint]

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

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

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

[@mouldydonut123]

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

[@mikecircelli9105]

The man, The myth, The Legend, Thank you

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

[@noumanali4847]

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

[@yulpereira3881]

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

[@rickcoleman]

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

[@scottgaines2677]

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

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

[@maxthepiguy3658]

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

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

[@anamariaanyana9552]

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

[@solobi2010]

THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL

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

[@user-tm1eq8rz5s]

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

[@InsightfulJourney123]

Thank you! Amazing teaching!

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

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

[@Jenicek25]

Thanks for clear explanation! It's very helpful!

[@freshgirl604]

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

[@kalkwok483]

Clearly presented and very helpful! Thank you.

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

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

[@rubychua1283]

Thank you. I find your explanation very clear.

[@tabban21]

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

[@erwinvanrheenen3276]

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

[@JohnOvens]

Excellent - great tips. Thanks Jon

[@deepanadhitya6455]

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

[@nischithp8378]

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

[@johnsolis6255]

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

[@patrickquinlan5292]

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

[@ExcelCampus]

Glad you liked it! 😀

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

[@franciscojrlarita441]

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

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

[@EdsonNascimentoEN]

Great tutorial thanks Jon.

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

[@jessietaber2179]

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

[@bhekinkosi419]

Struggled with this for months thank you

[@rrrpandey]

Very nicely describe , Easily understandable Thank you Very Much

[@sisteradmn]

perfect - got it right the first time - THANK YOU

[@jaliali84]

Awesome, simple and powerful

[@robinrogers7949]

Thank You!! Great video tutorial.

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

[@andrearagao5489]

Super useful! Thank you

[@hectorrapirap663]

Thank you. Verry nice presentation of merging sheets.

[@ShimadaConsultor]

Thank you!

[@sonnybr4711]

Thank you for saving my day!

[@Brwaa]

thanks so much Jon,its great lesson God bless you

[@luisfernandocuestasanchez4343]

God bless you man ¡¡ you are our saviour

[@shraddharangari]

Thanks helped me a lot looking forward for a macro

[@vsnduos217]

Perfect, thanks a lot!

[@Vinay6]

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

[@ExcelCampus]

Happy to help, Vinay! 😀

[@taniavincent8455]

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

[@seamushand8439]

Very well explained. Thank you

[@diegochavezsoria]

That was awesome! Thank you so much!

[@Ursula_33]

Simply outstanding teaching. Clear, concise and extremely helpful

[@ExcelCampus]

Thanks, Ursula! 😀

[@gajanandhumal8883]

Thank you very much.

[@krynauwkrowd8560]

Thank you your videos are amazing.

[@funese102]

Thank you so much, the tutorial is awesome

[@wissamaljuburi]

Hi Jon, awesome video man! Very useful!

[@rubenaugustine8666]

Thank you so much for this video.

[@NestorAdrianzen]

Awesome! Keep it up, Jon!

[@AutoDFensa]

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

[@ExcelCampus]

Glad it was helpful, @AutoDFensa ! 😀

[@katherinealindogan-tagudin7065]

Such a big help :) Thank you.

[@nikhilmay2]

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

[@tonic4834]

Great tutorial!

[@ferreiraferreira7392]

top tutorial. thanks!

[@nonoobott8602]

This is so helpful, thanks so much

[@robertjcliu]

It is helpful. Thank you.

[@coraliecuadra3021]

thank you!!!

[@mithunnv5628]

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

[@thomasabraham3107]

Beautiful thank you

[@allenlei2488]

very helpful, thx a lot

[@JigarPatel-lj5pv]

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

[@ExcelCampus]

Glad you liked it! 😀

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

[@jabulisilemalindi9590]

Thanks this was helpful

[@hobber_]

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

[@ExcelCampus]

Awesome, thanks for watching!

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

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

[@sophiabank9758]

You are a genuine

[@johnharker3478]

Thank you, simple and easy to follow along

[@ExcelCampus]

Thanks for the feedback, Jon! 😀

[@Henryerazo]

Wounderfull thanks for shared

[@lucyanamamat3666]

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

[@abellosimon]

Amazing!

[@mdibrahimsheikh1680]

Very Good Tutorial

[@prabhakararaon1649]

helpful ,good examples