Hi i have a table with a list of companies, which in some cases are
duplicated, and next to each company is a corresponding value. I want to be
able to return another table which returns the corresponding value for a
company, but if a company is duplicated then that company should only appear
in the returned table once but the value beside should be the sum of its
values. For instance i have

(First Table)
Company Amount
RBC 500
Suncorp 400
RBC 200

(2nd Table - What i would like returned)
Company Amount
RBC 700
Suncorp 400

Thanks
Simon.