I have four columns of values. I am looking for a solution - be it formula, macro, or anything else! - to produce a list of all combinations of those four columns of values, separated by a character of my choosing.
For example:
<tbody>
</tbody>
I would want this solution to result in a list - on another sheet or document, the end destination doesn't matter to me - that would produce in this:
Horse-Red-20"-Web
Horse-Red-20"-Retail
Horse-Red-30"-Web
Horse-Red-30"-Retail
Horse-Blue-20"-Web
Horse-Blue-20"-Retail
Horse-Blue-30"-Web
Horse-Blue-30"-Retail
Pig-Red-20"-Web
And so on!
I tried to find an existing thread with this issue, but failed.
I am using Excel 2007. Thank you for your help and attention!
For example:
A | B | C | D | |
1 | Horse | Red | 20" | Web |
2 | Pig | Blue | 30" | Retail |
<tbody>
</tbody>
I would want this solution to result in a list - on another sheet or document, the end destination doesn't matter to me - that would produce in this:
Horse-Red-20"-Web
Horse-Red-20"-Retail
Horse-Red-30"-Web
Horse-Red-30"-Retail
Horse-Blue-20"-Web
Horse-Blue-20"-Retail
Horse-Blue-30"-Web
Horse-Blue-30"-Retail
Pig-Red-20"-Web
And so on!
I tried to find an existing thread with this issue, but failed.
I am using Excel 2007. Thank you for your help and attention!