filmov
tv
How to Create a Pivot Table from Multiple Sheets in Google Sheets
![preview_player](https://i.ytimg.com/vi/wvQ_2i3q2qE/maxresdefault.jpg)
Показать описание
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
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