looking to add a number to identify each category

so example

column 1
Sports
Food & Nutrition
Food & Nutrition
Health & Fitness
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Food & Nutrition
Sports
Sports
Sports
what formula can i use to drag down so that column 2 becomes

Sports 1
Food & Nutrition 1
Food & Nutrition 2
Health & Fitness 1
Food & Nutrition 3
Food & Nutrition 4
Food & Nutrition 5
Food & Nutrition 6
Food & Nutrition 7
Food & Nutrition 8
Food & Nutrition 9
Food & Nutrition 10
Food & Nutrition 11
Food & Nutrition 12
Food & Nutrition 13
Sports 2
Sports 3
Sports 4
let me know if i am not making sense... hahahahah

thanks for the help in advanced!