Hi everyone,

Ram has been assisting me with an excel 2010 issue I have, but I had a thought which I figured might be a totally separate solution.

What I have is column A with a series of repeating values that that are of different lengths like the following:

XXX
XXX
XXX
YYY
YYY
YYY
YYY
ZZ
ZZ

is there any way I can create a column which combines column A with a number 1-4 and apply this number to the value in column A? The result would be:

XXX1
XXX2
XXX3
YYY1
YYY2
YYY3
YYY4
ZZ1
ZZ2

Thoughts?