Hi,

I would like to be able to generate all the possibles outcomes from three columns with numbers and letters.
The result should pop up in a different column and the order of the numbers and letters should stay the same and not change, e.g. A0101 is nothing I need. It should generate the possibilities as shown below if possible.

I am very new to VBA and Macros and I have a deadline for a work assignment and I could really need a hand with this.

01 A 01
02 B 02
03 C 03

--->

01A01
01A02
01A03
02A01
02A02
02A03
03A01
03A02
03A03
01B01
01B02
etc.

The real problem includes 12 numbers in each column and 5 different letters and I would like to be able to change the amount of numbers, letters and columns if needed.

If someone could help me with this it would be very appreciated!