List all possible combinations of a series of dropdowns

[tgo3200]

I would like to be able to create a list (concatenated field) of all possible combinations of a series of 4 dropdown boxes.

So for e.g.

DropDownList 1: A, B
DropDownList 2: X, Y

Would like to be able to generate the following list:

AX
AY
BX
BY

Any and all help would be appreciated.

Thanks
Tannia

[shg]

There's a workbook that shows two ways to do this, one with formulas and one with VBA, at https://www.box.com/s/47b28f19d794b25511be

[tgo3200]

THanks for the tool - the added complication that my data set has is that the drop-downs are dependent -drop downs, so in the tool your provided the link to certain appetizers would remove certain choices from the maincourse and dessert choices.
I tried to work thru the tool but do not think its possible to modify to work for dependent drop downs- correct?

[shg]

You should add your complications up front

You would need to generate a list for each of the primary dropdown items and its associated dependent items.

[tgo3200]

Agreed - unfortunately the complication had not revealed itself at the time of my original post!

Tried what you suggested re: building list by developing from the primary drop-down - but for some reason I got duplicates? Not sure what I was doing incorrectly ?

[shg]

Dunno. Post the workbook.

[tgo3200]

Attached example - Column G concatenates the 4 choices from drop-down, cells highlighted yellow are duplicates.
Feel I am missing a basic cue here - so risk getting egg (easter) on my face - but I really cannot figure it out.

Thank you.

[shg]

There are only 324 arrangements -- the value in C2. You will get all duplicates if you pull the formulas down further than that.

[tgo3200]

Thank you for the for the 'aha' moment!

[shg]

You're welcome.