CODEWITHSUNDEEP
google-sheetspivot
invalid_address
invalid_address

Reputation: 89

How to create a Google Spreadsheet pivot table from multiple sheets?

Is it possible to create a pivot table that consolidates data from multiple sheets?

Upvotes: 3

Views: 5230

Answers (1)

player0
player0

Reputation: 1

no, it's not. first, you will need to gather your data from all sheets with a query and then create your pivot table:

=QUERY({Sheet1!A:Z; Sheet2!A:Z; Shet3!A:Z}, "select * where Col1 is not null", 0)

Upvotes: 2

Related Questions