Hi,

I have 2 columns, as follows:

A1: apples
A2: pears
A3: oranges
A4: bananas
A5: grapes

B1: 1
B2: 2
B3: 3


I need in column C: the following:

C1: apples 1
C2: apples 2
C3: apples 3
C4: pears 1
C5: pears 2
C6: pears 3
C7: oranges 1
C8: oranges 2
C9: oranges 3
C10: bananas 1
C11: bananas 2
C12: bananas 3
C13: grapes 1
C14: grapes 2
C15: grapes 3

Very appreciative to any help on the best way to achieve this.

Best Rgds

Marcus