Auto add rows in table2 when unique entries added to column in table1?


Hi all,

I think this is probably really simple, but I’ve been trying lookups and filters and reading a bunch of forum posts without any luck.

I have a table1 with rows grouped by project. I want to make a table2 with each row corresponding to one project. When I try a lookup formula, it lists all the projects in each row. Is there a simple way to have a summary table with each row corresponding to a unique entry in a column in table1, which auto-updates when I add new entries to table1?

Basically like an =import in google spreadsheets if that makes sense.



Do you need to have a different table or is it just for summary’?

Filter created by to a summary table - there are two options there, let me know if neither work for you.

1 Like