Martin G.

Bo (. got it thank you much appreciated

If you use the lookup it will just tell you how if a row exists or not OR how many rows exist, I’m not sure how I would use that information to get the end result?

I watched the video but I am still not understanding, how do I get it to a point where all the names are just in one column

Thank you, is there a simpler way to do it without the lookup integration? (Something similar to this) as the names are already seperated in the list in the previous table

Thanks Bo (. was trying a workaround but the table is back as the extact same as before (Video here) let me know if you’re able to create a column in the “New Table” I am trying to put the first, second, and third owner names into one column Final output should look like this

You know what I mean? So there is one owner in each column

Yes but trying to make it so there is only one name IE for the company MSP corp row 2 should be “Habib Malik” and row 3 should be “Ravi Ramharak”

Yep go ahead

Basically

https://app.clay.com/workspaces/257254/workbooks/wb_0ta3mu8VFbP2c4buYBf/tables/t_0ta3ons7qTXyw6zdBDU/views/gv_0ta3ontGDNidxT4r6ft Video explaining step im at here