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.