2
2
25hp2017-09-28 17:22:04
excel
25hp, 2017-09-28 17:22:04

How to make a pivot table of 2 sheets in Google Sheets?

Hello, the question is in the title. Is this even possible in Google Sheets?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Elvis, 2017-09-29
@Dr_Elvis

No impossible. but you can write a script that, at the click of a button, will merge all the data from two sheets onto the third one and use it to make a pivot table on the fourth sheet.

S
Sergei Pogudin, 2020-07-30
@ManyHands59

You can do this without a script, and using the QUERY formula and then, based on a single table, make a summary

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question