Hello,

I have a worksheet with three columns of data (about 1200 rows). The sheet
looks as follows:

------A-------------B---

HE612413400v 7010B
HE612417800v 7020C
HE612422100v 8030D
HE612422200v 9040D
HE612422400v 9050E
HE612422900v 6040F
HE612424400v 5050F
HE612424500v 5741D
HE612424900v 5510D
6565D
5587E
5545E

etcetc

I would like to have a macro that does the following: In column C i would
like to have cell A1 & B1 merged, than A1&B2, than A1&B3 etc till the last
cell in column B and than start over again with A2&B1, A2&B2, A2&B3 etcetc
till all cells in column A are merged with all cells in column B. The result
will look like this

HE612413400v 7010B
HE612413400v 7020C
HE612413400v 8030D
HE612413400v 9040D
HE612413400v 9050E
HE612413400v 6040F
etcetc...(till last cell in B than second cell in A)
HE612417800v 7010B
HE612417800v 7020C
HE612417800v 8030D
etcetc... (till last cell in B than third cell in A)

I hope someone can help me... thanks in advance