Combining values of like cells

[ingenuity]

I need to merge cells and add the sums of the values in the next column

for example

col1 col2
name1 $5
name1 $6
name2 $1
name2 $3
name2 $2
name2 $1
name3 $2
name3 $1


how do i merge col1 and add the values in col2?
ie results should be:

name1 $11
name2 $7
name3 $3

Thank you in advance.

 

[Robert Mika]

Try PivotTable

 

[ingenuity]

Try PivotTable

Thank you, works great!