Filter duplicate values in Google Spreadsheets

Question

I have the following table:

[example]

How can I make a new table where all the duplicates are merged and the values are added together so I have a total per name ?

Answer 1

name    value
A   34
B   25
A   18
C   14
B   16
A   9
B   4
C   9

name    value
A   61
B   45
C   23

A:

SELECT name, SUM(value)
FROM tableName
GROUP BY name

Answer 2

use:

=QUERY(V:X; "select V,sum(W),sum(X) where V is not null group by V")