Published: 18 Jan 2019 › Updated: 18 Jan 2019

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:
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
- google query label replacement when using "group by"
- Date Time Replacement In IFTTT with settings and functions
- using query function with importrange
- Enumeration of dates between 'startdate' and 'enddate' using Custom function
- Managing working time using IFFTT (Location based)
- My favorite function ARRAYFORMULA in Google Spreadsheet
- Google Spreadsheet to Google Calendar using Zapier
- eval function in google spreadsheet; multi rows
- Date Time Replacement In IFTTT with google script
- Google spreadsheet data to Google Contact using Zapier