CODEWITHSUNDEEP
google-sheets
Bevo
Bevo

Reputation: 550

Google Spreadsheet : How to feed two sheets into a single pivot table?

I have two sheets with identical columns. I would like a single pivot table that combines the data together. Here is a sample data set:

https://docs.google.com/spreadsheets/d/1b_RWeOKghBA9w72ppEeCoQiS1cTmr2GpsfQB6TrwfeE/edit?usp=sharing

Upvotes: 1

Views: 1510

Answers (1)

e__n
e__n

Reputation: 717

Pivot tables only let you select a single range. Just combine the data from each sheet into a separate "helper" sheet and reference that range for your pivot table.

Upvotes: 2

Related Questions