I have a table which have a duplicate records for only one field that is Field A | Field B
a | djs
a | nsm
a | cns
Where field A contains duplicates
If the field contains duplicates then it shld be appended with 1,2 etc.. Is there a way of getting output as Field A | Field B
a | djs
a1 | nsm
a2 | cns
Thank you