Is it possible to have a pivot table on the same sheet as the data it's referencing in a Google Sheet?
At the moment if I create a pivot table it always creates a new sheet.
1
-
No, you can't (and pivot tables are ~evil~). Learn array formula. You can put a lot of pivot-like table in the same sheet using regular functions. It takes practice but worths the effort if you do lots of data analysis. – daniel Jul 26 '18 at 16:32
1
Simply select the cells of the pivot table you want to copy and then copy and paste it in the spreadsheet or sheet where you want it (or select desired cells and use CTRL + X and then CTRL + V to move it). If you want to, you can then delete the pivot table sheet.
