Count the number of occurrence upto now and assign a unique sequence number

Hi, Im new to the forum and trying to figure out if I can do this;

I have a list like this
ABC
ABC
ABC
ZYD
ZYD
QWE
QWE
ABC
ABC
ABC
ZYD
ZYD

and I need to have a sequence number assigned automatically in the next right column.
For example
ABC 1
ABC 2
ABC 3
ZYD 1
ZYD 2
QWE 1
QWE 2
ABC 4
ABC 5
ABC 6
ZYD 3
ZYD 4

The solution should give me unique sequence so at the end I can CONCATENATE them as
ABC1
ABC2
ABC3
ZYD1
ZYD2
QWE1
QWE2
ABC4
ABC5
ABC6
ZYD3
ZYD4

Please note that even ABC occurs at a later stage of the column it still gets a unique assigned number.

Keeping my fingers crossed and Thanking you all for taking time to solve my problem.

Cheers.

Originally Posted by AliGW

With your list in column A, this in column B copied down:

=A1&COUNTIF(A$1:A1,A1)

Hi AliGW,
That is pure magic !!!
Thank you so much ! Spent three hours searching for this and just after merely a blink of an eye after posting here, whola !
Thank you again.

Cheers

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by JohnTopley

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Ok noted. Thanks.
Done