How To Combine Excel Tables And Worksheets With Power Query

Подписаться 567 тыс.

Просмотров 345 тыс.

50% 1

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

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 283

@SuperZlatorog 3 года назад

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 3 года назад

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

@michelrail 2 года назад

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

@ryanjohnson1327 3 года назад

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

@rafaelperroni8212 2 года назад

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

@patrickkelley9057 2 года назад

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.

@scottgaines2677 2 года назад

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

@noumanali4847 3 года назад

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

@wayneedmondson1065 4 года назад

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

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

@mouldydonut123 3 года назад

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

@anamariaanyana9552 2 года назад

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

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

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

@fluffyhoneytina 2 года назад

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.

@yulpereira3881 3 года назад

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

@gabrielacattaneo7412 4 месяца назад

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

@ExcelCampus 4 месяца назад

You're welcome! 😀

@maxthepiguy3658 Год назад

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

@Men_dude 2 года назад

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.

@kalkwok483 4 года назад

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!

@tabban21 3 года назад

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

@cli3817 2 года назад

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

@freshgirl604 Год назад

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

@doreentetteh869 2 года назад

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

@rickcoleman 2 года назад

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

@djdtor 2 года назад

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!

@patrickquinlan5292 7 месяцев назад

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

@ExcelCampus 7 месяцев назад

Glad you liked it! 😀

@erwinvanrheenen3276 2 года назад

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

@Jenicek25 3 года назад

Thanks for clear explanation! It's very helpful!

@deepanadhitya6455 Год назад

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

@solobi2010 Год назад

THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL

@khumbulanisikhosana1347 2 года назад

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

@Kiranck1 2 года назад

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

@InsightfulJourney123 2 года назад

Thank you! Amazing teaching!

@emadrizkalla159 2 года назад

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

@mikecircelli9105 Год назад

The man, The myth, The Legend, Thank you

@user-tm1eq8rz5s 3 года назад

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

@RickWilliamsPlus 4 года назад

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 4 года назад

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.

@JohnOvens 4 года назад

Excellent - great tips. Thanks Jon

@abdul-azeezidowu9302 2 года назад

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

@meBuck76 4 года назад

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 4 года назад

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

@johnsolis6255 Год назад

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

@rubychua1283 3 года назад

Thank you. I find your explanation very clear.

@franciscojrlarita441 3 года назад

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

@darrylmorgan 4 года назад

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

@ExcelCampus 4 года назад

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

@michellguzelgul4267 8 месяцев назад

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

@ExcelCampus 8 месяцев назад

Thanks for the feedback Michell! 😀

@nischithp8378 Год назад

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

@shraddharangari 3 года назад

Thanks helped me a lot looking forward for a macro

@taniavincent8455 3 года назад

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

@EdsonNascimentoEN 3 года назад

Great tutorial thanks Jon.

@hectorrapirap663 2 года назад

Thank you. Verry nice presentation of merging sheets.

@rrrpandey 3 года назад

Very nicely describe , Easily understandable Thank you Very Much

@jessietaber2179 11 месяцев назад

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

@PrairieDogster 3 года назад

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

@AutoDFensa 10 месяцев назад

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

@ExcelCampus 10 месяцев назад

Glad it was helpful, @AutoDFensa ! 😀

@robinrogers7949 3 года назад

Thank You!! Great video tutorial.

@Ursula_33 Год назад

Simply outstanding teaching. Clear, concise and extremely helpful

@ExcelCampus Год назад

Thanks, Ursula! 😀

@jabulisilemalindi9590 Год назад

Thanks this was helpful

@diegochavezsoria 3 года назад

That was awesome! Thank you so much!

@SuzukiCentre 7 месяцев назад

Please accept my Hero Award! 🏆Just Excellent!

@ExcelCampus 7 месяцев назад

Thank you! 😅

@sisteradmn 2 года назад

perfect - got it right the first time - THANK YOU

@wissamaljuburi 2 года назад

Hi Jon, awesome video man! Very useful!

@allenlei2488 2 года назад

very helpful, thx a lot

@Whatisupbesties 3 года назад

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