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. 

combinations.yxmd