Hi ! Experts

My data look like this:
Name
Hardeep
Hardeep
pai
pai
renu
aditya
john
john
john
john
gorden
gorden

And i want to get the count of each name in next Column like mentioned below
Example

Name Count
Hardeep 2
Hardeep 2
pai 2
pai 2
renu 1
aditya 1
john 4
john 4
john 4
john 4
gorden 2
gorden 2