Create list of all pair combinations

[Nick]

Hello,

I have the following strored in separate cells in cells and need to create a list of pair combinations (42 pairs).

JMAT.L
CAR.L
TET.L
CRDA.L
VCT.L
DLTA.L
ELM.L

For example, for the first code all combinations would be the following?

JMAT.L CAR.L
JMAT.L TET.L
JMAT.L CRDA.L
JMAT.L VCT.L
JMAT.L DLTA.L
JMAT.L ELM.L

then I want to do the same for the next code in the list "CAR.L". Ideally I would like the combintion to be placed in seperate cells, e.g first part of the pair in column A (e.g JMAT.L in the example apve) and next part of the pair in Column B (CAR.L, TET.L etc).

ALso I need to do this with lists of different sizes (7 codes in the above) so would be good if any solution would be dynamic allowing different number of codes.

Hope someone can help,

Thanks,

Nick

 

[Juggler_IN]

@pgc01,

How do I get "unique" combinations from the Permutations_2 code?

Say I have a set {a,b,c,d,e} of 5 elements and i want to select 2 (up 5) as my p. And, I want only unique combinatios, ie. if AB is a first, then BA should not show up as it AB=BA. Essentially I want to see only the unique combinations.

Thanks.

 

[Juggler_IN]

@pgc01,

How do I get "unique" combinations from the Permutations_2 code?

Say I have a set {a,b,c,d,e} of 5 elements and i want to select 2 (up 5) as my p. And, I want only unique combinatios, ie. if AB is a first, then BA should not show up as it AB=BA. Essentially I want to see only the unique combinations.

Thanks.