Join all rows if a column into one row in differnt table

[jase1979]

I'm trying to achieve something that was reasonably easy in another app dev environment. 

I have a table with about 10 records, I want to take all of the rows from that column and join the rows into a single row in a column of another table. 

I could do this with the other software using a computed column that used a "joined list".

So far I've looked at REF_ROWS and CONCATENATE, however, I can't seem to get it to work and I'm not sure if it is the best solution using appsheets. 

Could you please help?

[WillowMobileSys · Accepted solution]

If you need the contents of the target column to update whenever the source is changed, then make the target column a Virtual Column.  It will update on a Sync.  I'm not certain if data updates will also affect a change but you can test that.

If for some reason that doesn't work well enough for you, the only other way to make it update automatically is to explicitly update the column through actions when the source changes.  If you go this route then use a "normal" column.