Combining several 'multiple select' columns


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



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


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

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