Help with matching values

[jvirtanen0201]

Hello!

I have a situation where I need to match values that are reversed. For example, I have one row which says apple/banana and another row which says banana/apple. For my purposes, apple/banana and banana/apple are the same thing and it doesn't matter which order the output is in. Can anyone help?

current output:

#	Type
1	Apple/Banana
2	Banana/Apple

desired output:

#	Type
1	Apple/Banana
2	Apple/Banana

Thanks in advance!

[cmcclellan]

Is it only ever 2 values ?

[cmcclellan]

See attached, a few more steps than is required for 2 values and 2 cells, but I'm guessing your real data is a bit more complex than this.

Basically I split, then sort the values, then connect them back together again.

[BenBo]

I think @cmcclellan is likely the better approach. I utilized the "CompareDictionary" function to reorder the strings in the list. 

[ponraj · Accepted solution]

Sample workflow