Would like if the below result can be achievable and what method..

Input data:

Name
Joemoe
tyu456
joe
kiin
froogle123
gtyo
froogle
Tyu


Desired result: To create unique ID..

Name ID
Joemoe 1
tyu456 2
joe 1
kiin 3
froogle123 4
gtyo 5
froogle 4
Tyu 2

Thanks.
Jimmy