I have the following table in a Google Spreadsheet:
Name | Value
A | 10
B | 100
A | 20
B | 200
C | 1000
How can I create another table based on a query:
select name, sum(value), count(value) from table group by name
so it looks like this:
Name | SUM | COUNT
A | 30 | 2
B | 300 | 2
C | 1000 | 1