I need to add all the data in columns B for all instances of a value occuring in column A
Fo eg

ColumnA Column B

Apple 4
Apple 5
Orange 3
Orange 5
Mango 2
Lemon 1
Lemon 9

I want the final result to look like this

ColumnA Column B

Apple 9
Orange 8
Mango 2
Lemon 10

Please help!

Thanks