I want to create every possible combination of numers from four columns of data. for example if the data looks like this:
A B C D
2 1 5 8
3 2 6 9
4 3 7 10
then I would like to see a list like the following:
2158
3158
4158
2269
3369
4469
etc.
until all possible combinations are created. Does Excel have a function that would help with this?
A B C D
2 1 5 8
3 2 6 9
4 3 7 10
then I would like to see a list like the following:
2158
3158
4158
2269
3369
4469
etc.
until all possible combinations are created. Does Excel have a function that would help with this?