Table of Contents
To remove the header from the results in a Google Sheets Query, you can use the “label” clause in the query formula and set it to “no_header”. This will exclude the header row from the query results. Additionally, you can also use the “headers” parameter and set it to “0” to remove the header row from the query results. By utilizing these options, the header row can be effectively removed from the query results in Google Sheets.
Google Sheets Query: Remove Header from Results
You can use the following formulas to remove the header labels from the results of a Google Sheets query:
Method 1: Remove Header from One Column
=QUERY(A1:C7,"select A, sum(B) group by A label sum(B) ''")
This particular example removes the header from the second column of the query results.
Method 2: Remove Header from Multiple Columns
=QUERY(A1:C7,"select A, sum(B), sum(C) group by A label sum(B) '', sum(C) ''")
This particular example removes the header from the second and third column of the query results.
Method 3: Remove Header from All Columns
=QUERY(QUERY(A1:C7, "select A, sum(B) group by A", 1), "select * offset 1", 0)
This particular example removes the header from all columns of the query results.
The following examples show how to use each formula with the following dataset in Google Sheets:
Example 1: Remove Header from One Column
We can use the following query to return the sum of points scored by each team and remove the header label from the sum of points column:
=QUERY(A1:C7,"select A, sum(B) group by A label sum(B) ''")
Notice that there is no header label for the sum column.
Example 2: Remove Header from Multiple Columns
We can use the following query to return the sum of points and sum of assists by each team and remove the header label from each of the summed columns.
=QUERY(A1:C7,"select A, sum(B), sum(C) group by A label sum(B) '', sum(C) ''")
Notice that there is no header label for the sum of points or sum of assists columns.
Example 3: Remove Header from All Columns
We can use the following query to return the sum of points scored by each team and remove the header label from each of the resulting columns:
=QUERY(QUERY(A1:C7, "select A, sum(B) group by A", 1), "select * offset 1", 0)
Notice that there is no header label for any of the resulting columns.
The following tutorials explain how to perform other common tasks in Google Sheets
Cite this article
stats writer (2024). How can I remove the header from the results in a Google Sheets Query?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-remove-the-header-from-the-results-in-a-google-sheets-query/
stats writer. "How can I remove the header from the results in a Google Sheets Query?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-remove-the-header-from-the-results-in-a-google-sheets-query/.
stats writer. "How can I remove the header from the results in a Google Sheets Query?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-remove-the-header-from-the-results-in-a-google-sheets-query/.
stats writer (2024) 'How can I remove the header from the results in a Google Sheets Query?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-remove-the-header-from-the-results-in-a-google-sheets-query/.
[1] stats writer, "How can I remove the header from the results in a Google Sheets Query?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I remove the header from the results in a Google Sheets Query?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.