Pivot Table from Multiple Sheets (Power Pivot, Power Query)
How to create a pivot table from multiple sheets in Excel using the PowerPivot and PowerQuery add-ins. This example demonstrates creating a pivot table from three sheets containing a total of 3 million rows!
Video tutorial files:
PowerPivot version https://disk.yandex.ru/i/ah6hsfymXjBE_g
PowerQuery version https://disk.yandex.ru/i/-ylJj-B7FfmH0g
Timecodes:
1:11 Pivot table based on PowerPivot
5:42 Pivot table based on PowerQuery
======================================================
Join our VK group:
Download our PowerQuick add-in to speed up your work in Excel: https://xn----btbktgundek1hji.xn--p1ai/download.html
Download our free PowerFin add-in from Financial calculators: https://xn----btbktgundek1hji.xn--p1ai/subex-finance.html