Need help creating VBA code to form permutations

Hi all,

I am having trouble finding a code that will create all possible permutations, but within a specific grouping only. For example, below, I want the permutations for A to be only within A and those for B to be only within B. The only codes I have been able to locate so far only consider the full list (ex: would create a permutation of catorange in the example below).

BEFORE:
A apple
A orange
A banana
B cat
B dog
B lion

AFTER:
A appleorange
A applebanana
A orangeapple
A orangebanana
A bananaapple
A bananaorange
B catdog
B catlion
B dogcat
B doglion
B lioncat
B liondog


Any help on getting this code would be greatly appreciated!

Thank you!

Hi,

I have attached an example excel file. The data list begins in $b$3 and I would like the final data to be pasted in column C.

Thanks!

This is exactly what I need - thank you so much!

Is there any way you could also show me the code for the same permutation but separated into two columns? In the attached file, I just separated out the letters from the words in columns B and C and would also like to see the permutations listed in columns D and E.

Thanks again!

Thank you for getting back so quickly! I do have one small change - is it possible to update the result to split out the two words into different cells? In this example, the first permutation would put "A" in column D, "Apple" in column E, and "Orange" in column F.

Thanks!

Perfect! Thanks again for all your help - you saved me a lot of time!

Best,

Nicole