MENU

Fun & Interesting

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

Chester Tugwell 109,028 lượt xem 2 years ago
Video Not Working? Fix It Now

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
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: https://www.microsoft.com/en-gb/download/details.aspx?id=39379

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

Comment