Creating standard unique combinations

[VaibhavLakhotiya]

Hi,

I have a column with data as "apple+mango+banana","apple+banana+mango","mango+apple+banana". I want to set a standard combination "apple+banana+mango". for all these three rows. How do i acheive this?

[Luke_C]

Hi @VaibhavLakhotiya 

Here's how I'd approach this:

1. Split the data to rows
2. Sort it
3. Concatenate it back