How to Join Tables in Excel | Merge or Append Data From Different Sheets Using Power Query

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

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

50% 1

In this video I demonstrate how to join tables in Excel. You may want to either append or merge data in Excel: both tasks can be achieved using Power Query. Once you have housed your data in Excel tables, you can use Power Query and the Power Query Editor to join and transform your data.
If your version of Excel doesn't include Power Query, you can download it here: www.microsoft.com/en-gb/downl...
Table of Contents:
00:00 - Introduction: append vs merge
01:01 - How to append tables using Power Query
05:39 - How to merge tables using Power Query
------------------------

Хобби

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

7 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

I was today years old when I made my first table and merged my first spreadsheet. This has saved me so much time. Thank you!

@shivamrawal2215 10 дней назад

this was a lifesaver. Thanks!

@26262121 9 месяцев назад

This is the only video that really worked for me having the same value in different sheets and with mutiple data data rows pulling from the same value. Thanks you!!!

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

Excellent explantaion of merging different excel tables, thank you!

@IvanCortinas_ES Год назад

Yeah. Excellent and productive video. Thank you Chester!!!

@yary111 Год назад

Can't wait to try this at work tomorrow!! Thank You!

@blaiseganguin4710 Год назад

Brilliant - thanks for taking the time to share!

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

Thanks Chester! Helped me a great deal. I am working on an Assets Register with different types of Assets on their own separate tables, appending those was an hustle for me until I came across this. Keep up the great work! Chees 😁👍

@chettri77 Год назад

Great Video. Thanks a lot; after watching your video I was able to do my task more efficiently ( saved a lot of time). Your instructions are very clear and easy to understand.

@ChesterTugwell Год назад

Great to hear!

@pemotor541 Год назад

Amazing! What about the situation in which I would have rows that are unique (complementary) to the first table? Could we add those as well? to complete the first one everything else is compared to?

@simonfreeman8233 9 часов назад

Come to a video about merging data finally learn how to change date format that's been causing me headaches for eons

@andiglatz7045 Месяц назад

Best one!

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

Hi Chester, this is great thx! have one question at this moment, for the 'merge' example. Having set this all up, are future additions to the original tables automatically incorperated in the 'endresult' Thx in advance!

@taffman1 Год назад

Very interesting, helps me a fair bit, but I have five identical tables that I need to merge (one for each colleague), how do I do this?

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

Awesome video. What if you need to update the table ranges for each statement in the appended columns example? Is there an easy way to do that?

@ge7m8YT 2 месяца назад

Great video. It helped a lot with one of my projects, recently. The 'append' function worked better in my case. However, when I click the refresh button, then more rows are added without adding any extra data in the tables. How can that be fixed?

@Aaron-cc7yq 3 месяца назад

THHHAAAAANNNNKKKKK YYYYOOOOUUUUU!!!!!

@ChesterTugwell 3 месяца назад

👍

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

Really useful and well explained - just discovering the power of PoweQuery!

@mortenlanda2211 2 месяца назад

Takk!

@ChesterTugwell 2 месяца назад

Many thanks

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

Is there a way to get this to work with tables from different files as opposed to tables in the same file?

@user-ye3qb4ou3m 5 месяцев назад

Great video. I'm having trouble appending my tables. It's giving me additional columns! Also, it's not appending on top of each other! Please can you help!!

@annietrinh4693 9 месяцев назад

Before i merge 2 tables, my first table have 210 lines, after i merge date only left 150 lines. How can i merge based on table 1 with 210 lines? Combine 150 lines from table 2 into table 1 but keep the rest data even not match