Split and join multi-select values into new column

laurablox

Hi,

I'm attempting to get a function as per below.

I've tried a few methods and it doesn't seem to work. Can anyone help?

laurablox

I've solved this with a bunch of

IF(Contains([input]@row,"XX"),"XX") + char(10) + IF(Contains([input]@row,"YY"),"YY") + char(10) + etc etc's.

If anyone has a more clever solution, please let me know! Thanks!

laurablox

I've solved this with a bunch of

IF(Contains([input]@row,"XX"),"XX") + char(10) + IF(Contains([input]@row,"YY"),"YY") + char(10) + etc etc's.

If anyone has a more clever solution, please let me know! Thanks!