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

Описание к видео How to Join Tables in Excel | Merge or Append Data From Different Sheets Using Power Query

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

Комментарии

Информация по комментариям в разработке

Похожие видео