Multiple occurrence => 1 occurrence

Hi,

I have an excel file with 2 columns (product, price)

In this file I have multiple occurrence of products :

Product     Price
Beer            4
Soda            5
Beer            6
Chocolate       2

I have two occurrences of beer, I want to have only one with the price being the average of the two.

Product     Price
Beer            5
Soda            5
Chocolate       2

Thanks