Hi Everyone, I hope someone can help me approach this situation...

I have over 4000 rows of names and dollar amounts. I can't sort this by types of dollar amounts cause the names are only listed once... for example..

Name Food Type Price
Don Milk $1.99
Vegies $5.99
Meat $4.99
Snacks $11.99
Bob Milk $4.99
Vegies $3.99
Meat $15.99
Snacks $1.99

My question is how do I auto populate the cells below Don up until Bob and then populate the cells below Bob until the next person? Is there a formula? Macro? Something?