How to Create a Pivot Table from Multiple Sheets in Google Sheets

preview_player
Показать описание
In this video, I show how to create a pivot table from multiple sheets in Google Sheets. To do this, you need to get all of your data consolidated into one sheet. You can either do this manually or use the QUERY function to consolidate your data.

Read through the full tutorial here:

Timestamps:
00:00 Intro
1:10 Consolidating Data Manually
1:59 QUERY function to Consolidate Data
4:22 Creating the Pivot Table
Рекомендации по теме