All the possible combination of 2 columns

[User93]

Hi, I have two columns, e.g.

Name1	Name2
Method1	a
Method1	b
Method2	a
Method2	b
Method2	c
Method2	d

I need to have all the combination of these two columns and the result should be:

Method1-a

Method 1-b

Method1 a-b

Method2 a

Method2 b

Method2 c

Method2 d

Method2 a b

Method2 a c

Method2 a d

Method2 a b c and so on. Is this possible? Thanks.

[BrandonB]

Branch off the data set into two summarize tools. Group by the first column in one summarize tool and group by the second column in the other summarize tool. This gives you a unique list of every value in both columns. Then use the append tool to append the output of one summarize tool to the other. This will create the combination of each value pair. 

[User93]

Hi, this gives me only  the first two, but I need all the possible combination, so also Method 1-a-b

Method1-a

Method 1-b

Method1 a-b

[KSowers]

Would you also need Method1 b-a?

[User93]

Hi, no, I have that in the other table.

[KrishnaChithrathil]

@User93 

Will this help you anyway? Donno how your actual data would look like. 😀