In this tutorial, you will learn How to use the Label Clause in Google Sheets Query
Label clause can be used in Google Sheets Query to create or delete labels in a column with output in Query format.
How to use the Label Clause in Google Sheets Query: Step by Step Guide
Enclosed are the steps to use the Label Clause in Google Sheets Query
Use the following syntax to set label for a column using a Query
=QUERY(A1:C10, "select * label A 'Column A'")
In the below example we will see how to use the above-provided formula.
First Example: How to use the Label Clause with One Column
You can use the below query to select football teams with Matches played and Points scored
=QUERY(A1:C10, "select * label A 'Football teams'")
The above formula will result in renaming the “teams” label to “Football teams” However Matches played and Points label will remain as it is.
Second Example: How to use the Label Clause with Multiple Columns
You can use the below query to select football teams with Matches played and Points scored and then get labels renamed for multiple columns such as teams to “Football teams” and “Matches Played” to “Played“
=QUERY(A1:C10, "select * label A 'Football teams',B 'Played'")
In the above screenshot, you can notice the two labels have been renamed,
- teams to Football teams
- Matches Played to Played
You can customize the above-provided query as per your requirement and rename the label for one or more columns
How to use the Label Clause in Google Sheets Query(Conclusion)
In the above tutorial, we have provided you with the steps on How to use the Label Clause in Google Sheets Query.We hope this tutorial was useful.
Related articles :
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets