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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.