Can somebody help me figure out how to find every combination possible for 2 columns of data? The tricky part here has to do with the 2nd Columns list of data. This column has to be calculated to figure every combination of itself as well. This might be much easier to explain with an example. Below is an example of what I'm looking to do.
Column A Column B A Apple B Banana C Orange D Pear Watermelon Kiwi Cantaloupe Strawberry Melon
Results I'm looking for: (This example is only going to show all the results for 'A')
A, Apple
A, Banana
A, Orange
A, Pear
A, Watermelon
A, Kiwi
A, Cantaloupe
A, Strawberry
A, Melon
A, Apple, Banana
A, Apple, Orange
A, Apple, Pear
A, Apple, Watermelon
A, Apple, Kiwi
A, Apple, Cantaloupe
A, Apple, Strawberry
A, Apple, Melon
A, Apple, Banana, Orange
A, Apple, Banana, Pear
A, Apple, Banana, Watermelon
...
...
...
...
...
...
A, Apple, Banana, Orange, Watermelon, Kiwi, Cantaloupe, Strawberry, Melon
As you can see, doing this by hand is proving to be somewhat cumbersome and quite frankly, a huge waste of time that has many opportunities for human error. I'm hoping that there is somebody on here that has an easy solution for resolving this problem, because I am stumped, and my brain hurts from trying to figure it out.
I guess I should also mention that the 'Column A' data will never need to be included in the subset combination sequence. Meaning, there will never be a result of "A, B, C, Apple, Banana, Orange, Watermelon....etc.". It will always only be an single cell of data from 'Column A' preceding each combination result from 'Col B'.
Thank you in advance to whoever the certifiable genius is that can figure this out!
-Mike in Sacramento, CA.
Bookmarks