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 ?

CodePudding user response：

use:

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

CodePudding user response：

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