I want to get a serial number every time a value repeats in the column.as given in the below example.
Fruit name Desired results
Apple 1
Guava 1
Mango 1
Banana 1
Apple 2
Guava 2
Apple 3
Guava 3
Mango 2
Apple 4