[ Ссылка ] Visit this page to download the sample file.
Use Excel Power Query to combine data from multiple worksheets, if tables have some columns with identical names. Then, create pivot table from the combined data.
If you update the original tables, use the Refresh or Refresh All commands, to update the Power Query tables, and the pivot table.
00:00 Introduction
00:42 Create a Query Using Power Query
01:29 Get Data from Second Table
02:02 Combine Data from Both Tables
03:11 Create a Pivot Table
03:39 Change the Data and Refresh
5:00 Use the Refresh All Command
5:59 Conclusion
6:08 Get the Sample File
Watch this video to see how to combine the data from two similar tables, create a pivot table, and refresh the data.
![](https://i.ytimg.com/vi/GOfoM0hwVkQ/maxresdefault.jpg)