I have a spreasheet with items by dealer--some have 1 item, some have 2 or
more. Each item is a separate row. I need to renumber the items by each
dealer like below:

joe book 1
joe cap 2
joe car 3
tom book 1
jill car 1
jill book 2

any help is greatly appreciated.

Thanks