I have a table with columns: PID, Project name, ... (14 Columns) like this

PID Project_name Department Plan Effort estimation ....

111 Project1         qw          50     60

111 Project1         sw          40     50

222 Project2         sw          40     50

I want to automatically create a tab for each PID, so that I have a tab named 111 with all data with PID 111 from sheet1, tab 222 with all data with PID 222... when I import the table from Excel into Google spreadsheets. Could someone help me?

  • Welcome. The question is too broad for this site. Please add a brief description of you search/research efforts as is suggested on How to Ask. – Rubén Nov 27 '18 at 15:49
  • Something like here webapps.stackexchange.com/questions/99344/… but here will be no tabs created automatically. I think it must be like this (pseudo code): create tabs =UNIQUE(MasterSheet!A2:A) copy data =FILTER(MasterSheet!A2:Q60000, MasterSheet!A2:A60000 = "UNIQUE PID") – Alex7 Nov 28 '18 at 10:47
  • I found an google sheet add-on Tabify, which does exactly what I'm looking for, but it unfortunately hangs after some time (my table has ~60000 rows). – Alex7 Nov 28 '18 at 11:29
  • An add-on works well, it hangs because of the limit of 5000000 cells. – Alex7 Nov 28 '18 at 12:28
  • Are you saying that you need 60000 tabs? – Rubén Nov 28 '18 at 13:05

The problem is solved. Google sheet add-on Tabify does that. This add-on allows you to filter sheet results into new tabs.

"Tabify allows you to organize your spreadsheet data or Form Responses by creating a tab for each unique value found in a column. It will add tabs (sheets) to the spreadsheet based on the column you choose."


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.