Merge multiple rows based on column and sum values (Excel, Google Refine, Google spreadsheet)

Question posted 2013 · +6 upvotes

I have large amount of rows, which look like:

| Name   | Value |
|--------|-------|
| name 1 | 12    |
| name 1 | 10    |
| name 1 | 1     |
| name 2 | 55    |
| name 3 | 1     |
| name 3 | 8     |

I need to merge all rows into one row based on column “Name” and sum “Value” in relevant rows. Result should be:

| Name   | Value |
|--------|-------|
| name 1 | 23    |
| name 2 | 55    |
| name 3 | 9     |

Rows with the same “Name” could be 0-n.

How can I do it in Google Refine or in Excel/Google Spreadsheet?

I am thinking of it, but with no solution.

Thank you a lot!