Hello everyone, I’m a beginner with airtable.
I imported a csv in airtable (i used to work with googlesheet), a database of people for a recruitment activity. I have several columns : name, email, etc… and 3 sectors in 3 different columns. I defined the content of my sectors columns as “multiple select” (because i would like after to make people fill through forms with multiple choices). I would like to have only one column centralizing all the 3 sectors of one person with different tag (which is called “options” in airtable, because the column nature is “multiple select”). If someone has “bank” in the first column, “insurance” in the second one and “energy” in the third one, I would like only one column with 3 “options” (like tags) : “bank” / “insurance” / “energy”. I have 3000 lines so I don’t want to do it manually. I already tried to use different formula but the result is not good , I have the 3 words in my target column , I don’t want the 3 words but I want 3 “options” in the same case. Thank you for your help