Hi,

I have a sequence of 6 strings (3 each in 2 categories)

Category Brand(B) : A, B, C
Category Product (P): D, E, F

I am trying to work out an sequence like BBBPPP using each ad from the B and P categories and have all combinations, maintaining the BBBPPP order.

Example:

ABC DEF
CBA DEF
BCA DEF
----
----
----

Is there a way I can do this in Excel where I can automatically list these combinations? I have been trying to play around with the PERMUT and COMBIN functions with no luck. I want it to output the actual sequence and not the # of iterations possible.

Any help is appreciated.

Thanks!