Formula for multiple columns into one column or a separate table

I have a table like in Screen Shot 1. I spent a few hours here looking for a solution on how to get a column like the green one in the screenshot or another table like in the second screenshot. Any hint would be greatly appreciated.

Thanks in advance

Screen Shot 2020-05-30 at 12.03.59 PM , N

Hello! You’re nearly there, you don’t need a formula to maintain this - Just to convert it to a comma separated list - then you can just create a “Linked To field”

Please see below for a preview of the Airtable Structure you need, but first, let me explain how I got there:

  1. Create a base in Airtable, as you have done
  2. Create a formula to create a comma-separated list of all of the tags - E.g.

{Tag1} & "," & {Tag2} & "," {Tag3} etc..

  1. Turn this formula field into a Linked to record, and link it to Table 2

And here’s the result:

1 Like