# How to group data in a Google Spreadsheet?

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
``````
-

## migrated from superuser.comDec 1 '12 at 7:29

This question came from our site for computer enthusiasts and power users.

## 2 Answers

By using the `QUERY` function you can achieve your goal.

## Formula

``````=QUERY(Data!A1:B6;"select A, sum(B), count(B) group by A")
``````

## Screenshot

Using other functions, makes it achievable as well.

``````add this formula in A2:
=UNIQUE(Data!A2:A)

add the following formulas in B2 and C2 and copy down to B4 and C4 respectivey
=SUM(FILTER(Data!\$B\$2:B;Data!\$A\$2:A=A2))
=COUNTA(FILTER(Data!\$B\$2:B;Data!\$A\$2:A=A2))
``````

## Example

I've made an example file for you: QUERY vs. FUNCTIONS

-

You can use Pivot Tables to group data in Google Spreadsheets.

-
Why -1? Pivot Table definitely does it! googledocs.blogspot.com/2011/05/… – Mehper C. Palavuzlar Dec 1 '12 at 10:50
Because the question was about doing it with SQL – Jacob Jan Tuinstra Dec 1 '12 at 11:13
He wants to create another table which he clearly defines in the question, and Pivot Table does create this table. This is a valid answer. – Mehper C. Palavuzlar Dec 1 '12 at 13:37
@JacobJanTuinstra no he doesn't. – spartacus Aug 6 '14 at 7:42
Pivot Tables should probably be mentioned in the question comments section instead. It is definitely helpful and related, but not answer the question precisely - only because the question was specifically about a query and the `QUERY` function is the answer. – Dave Dec 21 '14 at 18:01