How to Create a PivotTable From MULTPLE SHEETS in Excel (Different Headers or With the Same Headers)
Автор: Chester Tugwell
Загружено: 2021-11-11
Просмотров: 25980
👍👍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...
Thank you! 👍👍
Download the featured files here:
Different headers example: https://www.bluepecantraining.com/wp-...
Same headers example: https://www.bluepecantraining.com/wp-...
In this video I demonstrate how to create a PivotTable based on multiple worksheets in Excel. There are two scenarios where this might be needed:
1) You have related data and the column headers are different on each sheet. In this is the case you will need to add each table to the Data Model and then establish relationships using primary and foreign keys.
2) You have related data and the columns headers are the same on each sheet. In this case you will need to use Power Query to append the sheets together.
Table of Contents:
00:00 - Intro
01:00 - Sheets have different headers
05:08 - Sheets have the same headers
09:24 - Updating (sheets have the same headers)
10:57 - Updating (sheets have different headers)
------------------------
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: