zero6pak avatar

google query label replacement when using "group by"

zero6pak

Published: 18 Jan 2019 › Updated: 18 Jan 2019google query label replacement when using "group by"

google query label replacement when using "group by"

Google query function return data ranges's header when using "group by".

The header includes property. Such as count, sum.

You can use as below.

=QUERY(F2:G4,"SELECT F, SUM(G) GROUP BY F LABEL SUM(G) '합' ",1)

F2:G4 is data range.

[label is not used]
구분 | sum count {colname}
col1 | col2

[label is used]
구분 | 합
col1 | col2

You can express it more clearly and pretty.

Leave google query label replacement when using "group by" to:

Written by

Read more #spreadsheet posts


Best Posts From zero6pak

We have not curated any of zero6pak's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.

More Posts From zero6pak