How to properly group by in a Google Query

Question

717 views Asked by Michael Kenworthy At 19 December 2016 at 06:35

I'm trying to get the following table from the query shown in the image below.

 ------------
| Mike  | 60 |
| Zoe   | 50 |
| Abby  | 20 |
| Jimmy | 80 |
| Joe   | 90 |
| Ken   | 80 |
 ------------

On the first line in E is

=QUERY(A2:B9,"select avg(B) group by A")

Things I'm confused about

On E3 I just added A to see if that changed anything

On the last line, I specified that there was one header and used the whole table of data

There are 1 answers

**Michael Kenworthy** · Answer 1 · 2016-12-19 07:30:39

Michael Kenworthy On 19 December 2016 at 07:30

The issue here was that I didn't have the proper data-type selected for the cell contents...