Obtain all possible combinations of values in 2 or more columns, NOT from a single column

[Rob48]

Hi, i'm looking to create all possible combinations between two columns without including any combinations of values from the same column.

Here's a sample of what i'm trying to do:

Column 1	Column 2
A	1
B	2
Desired Result
A / 1
A / 2
B / 1
B / 2
1 / A
1 / B
2 / A
2 / B
Do not want
A / A
A / B
B / A
B / B
1 / 1
1 / 2
2 / 1
2 / 2

the values are all strings not numbers, and they all have different lengths. I also need the " / " between each item.

Thanks!

[fmvizcaino · Accepted solution]

Hi @Rob48 ,

I'm attaching an example showing how to get that done.

Let me know if is that what you are looking for.

Best,

Fernando Vizcaino

[Rob48]

Thanks, that did it!

[akshaydalvicia]

How to do it when you have more than 2 columns with varying size of datasets within each column? How to get all the permutations?