In this tutorial, you will learn How to Remove Header from Results using the Google Sheets Query function.
How to Remove Header from Results Google Sheets Query: Step-by-Step Guide
Here’s How to Remove Header from Results in Google Sheets Query.
Approach 1: Using the “offset” function
With the use of “offset” function you can shift the data range by a specific number of rows or columns.
To remove header row simply select the cell where you need to get the result and use the below query function to shift the data range by one row down
=QUERY(A1:C10, "SELECT A, B, C OFFSET 1", 0)
In the following example we have a dataset A1:C10, and we need to display all the rows and columns in the range, except for the first row (which contains the header).
When we use the “offset 1” function it shifts the range down by one row, effectively skipping the header row.
Example 1 : Using the “offset” function
Method 2: Using QUERY function to Remove Header from One Column
=QUERY(A1:C10,"select A, sum(B) group by A label sum(B) ''")
The above query removes the header from the second column of the result.
Let’s see the above query in action with a practical example
Example 2: Using QUERY function to Remove Header from One Column
The following query will remove the header label from the points scored column and return the total points scored by each team:
=QUERY(A1:C10,"select A, sum(B) group by A label sum(B) ''")
In the above screenshot, you will notice that the second column has no header
Approach 3: Using QUERY function to Remove Header from Multiple Columns
=QUERY(A1:C10,"select A, sum(B), sum(C) group by A label sum(B) '', sum(C) ''")
The above query removes the header from the second and third columns of the result.
Example 3: Using QUERY function to Remove Header from Multiple Columns
The following query can be used to obtain the total points scored and total matches Lost by each team while also removing the header label from each of the summed columns.
=QUERY(A1:C10,"select A, sum(B), sum(C) group by A label sum(B) '', sum(C) ''")
In the above screenshot, you will notice that the second and third column has no header
Approach 4: Using the QUERY function to Remove Header from All Columns
=QUERY(QUERY(A1:C10, "select A, sum(B) group by A", 1), "select * offset 1", 0)
The above query removes the header from all columns of the result.
Example 4: Using the QUERY function to Remove Header from All Columns
You can use the below query to get the points scored by each team and remove the header from all the columns.
=QUERY(QUERY(A1:C10, "select A, sum(B) group by A", 1), "select * offset 1", 0)
How to Remove Header from Results Google Sheets Query(Conclusion)
In the above tutorial we have shown you various methods using which you can quickly remove Header from Results in Google Sheets.
We hope this tutorial on How to Remove Header from Results was useful.
Related articles :
How to Convert Numbers to Strings in Google Sheets(Quick & Easy Guide)
How to Calculate Average If Cell Contains Text in Google Sheets
How to Combine First and Last name in Google Sheets(Quick & Easy Guide)
How to Round to Significant Figures in Google Sheets(Quick & Easy Guide)