# Automatically create rows in a table for each unique value found in another table (multiple columns and rows) **URL:** \ **Category:** Ask the Community\ **Created:** [April 15, 2020, 1:53pm UTC](https://connect.superhuman.com/t/automatically-create-rows-in-a-table-for-each-unique-value-found-in-another-table-multiple-columns-and-rows/15156 "2020-04-15T13:53:54Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Brenton\_M](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brenton_m/32/14180_2.png) [@Brenton\_M](https://connect.superhuman.com/u/Brenton_M)\ **Post date:** [April 15, 2020, 1:53pm UTC](https://connect.superhuman.com/t/automatically-create-rows-in-a-table-for-each-unique-value-found-in-another-table-multiple-columns-and-rows/15156/1 "2020-04-15T13:53:54Z")
Hi! I have a sorta-tricky problem that I can’t figure out: I want to take the contents of multiple cells (across multiple rows _and_ columns) in one table (“Movie Table”), parse unique values, and automatically add/remove rows from another table (“People”) for each unique item. I think it’s a two-part problem: **Problem 1. Create a list (is a list the best output for this use case?) containing each _unique_ value found across multiple columns and rows.** Right now, I’m doing this via the formula `Split(ListCombine([Movie Table].Director,[Movie Table].Producers, [Movie Table].Starring,[Movie Table].[Written by]).Unique(),", ")`. For now, this allows me to create a select-list in the “People” table that shows only unique values. **Problem 2: automatically add/remove rows to a table based on the contents of unique values contained within multiple cells in a different table.** Now that I have my list of unique values, I want the “People” table to automatically add/remove rows whenever this list of unique values changes. For example, if I add actors to the movie Okja in the “Movie Table” table, I want a new row in the “People” table to appear for each actor. If I remove the name of a producer for a different movie (and if that person isn’t listed anywhere else), I want their row in the “People” table to be removed. Removing rows is more of a nice-to-have, though. Here’s a copy of my doc: https://coda.io/embed/wn_vbfSO0u/_suvX5?viewMode=embedplay ---
**Author:** ![Saul\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/saul_garcia/32/16406_2.png) [@Saul\_Garcia](https://connect.superhuman.com/u/Saul_Garcia)\ **Post date:** [April 15, 2020, 2:05pm UTC](https://connect.superhuman.com/t/automatically-create-rows-in-a-table-for-each-unique-value-found-in-another-table-multiple-columns-and-rows/15156/2 "2020-04-15T14:05:07Z")
Hello @Brenton_M! Could you update your share permissions so we can access your doc please? Thanks! ![Share a document publicly](https://global.discourse-cdn.com/coda1/original/2X/4/4f94f67101fdc2e3c1b6487c2089718d26cba31a.png) ---
**Author:** ![Brenton\_M](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brenton_m/32/14180_2.png) [@Brenton\_M](https://connect.superhuman.com/u/Brenton_M)\ **Post date:** [April 15, 2020, 2:11pm UTC](https://connect.superhuman.com/t/automatically-create-rows-in-a-table-for-each-unique-value-found-in-another-table-multiple-columns-and-rows/15156/3 "2020-04-15T14:11:17Z")
@Saul_Garcia whoops! It should be viewable now - thanks for the heads up. ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [May 6, 2021, 9:10pm UTC](https://connect.superhuman.com/t/automatically-create-rows-in-a-table-for-each-unique-value-found-in-another-table-multiple-columns-and-rows/15156/4 "2021-05-06T21:10:15Z")
Did you ever figure this out, @Brenton_M?