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 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 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 at 11:29
  • An add-on works well, it hangs because of the limit of 5000000 cells. – Alex7 Nov 28 at 12:28
  • Are you saying that you need 60000 tabs? – Rubén Nov 28 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."

https://www.youtube.com/watch?v=YN51XbsDbRY

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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