flag/mark duplicates with time increament

[tds1225]

I have a list of servers and WS and would like to add time at the end of each duplicate SERVER. I wrote a batch file to do this already but would like to know if anyone can show me how to use excel for it

SERVER1 WORKSTATION1
SERVER1 WORKSTATION2
SERVER2 WORKSTATION1
SERVER1 WORKSTATION3
SERVER3 WORKSTATION1
SERVER2 WORKSTATION2

The result i like to have

S1 WS1 1
S1 WS2 2
S2 WS1 1
S1 WS3 3
S3 WS1 1
S2 WS2 2

AND SO ON....

Thanks for any help