How to only Concat cells combining all permutations for a single identifier.

[walkingbird]

i have the following input. 

and need the output in the following format after concatenating .

Can you pleas take a look at the input and output and let me know what would work best in this scenario.

[RobertOdera]

Hi, @walkingbird 

If I understand your post correctly:

1. you want all combinations

2. combination Sam & Rita is the same as Rita & Sam

Kindly consider the below.

I hope you find it helpful - Cheers!

[Yoshiro_Fujimori]

Hi @walkingbird ,

Here's one potential solution using Batch Macro.

I hope this helps.

Main workflow

Batch Macro

Output