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