Concatanating values from each column with each other

[Szwadron6]

Hi everyone,

I would like to ask you for help with creating a macro that would combine all information in attached file like following:

There are 10 columns with in each there is one digit (or a dot). I would like to create a macro that would combine all possible comibinations and created a list for me like:

KMFD...BAK
KMHD...BAK
KMJD...BAK
KMFD...CAK
KMFD...CAK
KMHD...CAK
KMJD...CAK
....
....
....


so in short to display me a concataned list whre every digit in each column is combined with every single digit from other columns.

Is that achievable with a macro?

Thank you in advance for any tips.

[karedog]

First, you must empty range A3:B4, because these cells are duplicates (from A2:B2).
Then you can run this macro :

Please Login or Register  to view this content.

[Szwadron6]

Many, many thanks. Works perfect!

[karedog]

You are welcome, thanks for marking the thread as solved and rep.points given.

Regards