Combining several 'multiple select' columns


#1

Hi guys

We have several columns including ‘multiple select’ options within and wish to combine all these columns into one.

Is there a way to do this across the entire table, or do we need to manually duplicate the options and then manually go through each record to combine everything?

Many thanks in advance

Harvey


#2

Maybe a formula with a CONCATENATE function of 2 fields, and then Converting it to Multiple Select? Let me try :sweat_smile:

Demo: https://airtable.com/shrHwcqyUJjAmatho

Formula: Multiple1 & ',' & {Multiple2}.

I think if would be more Multiple Select fields we would need any function, but it works :grin: