How to use the Label Clause in Google Sheets Query(Quick & Easy Guide )

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'")
How to use the Label Clause in Google Sheets Query
How to use Column and Columns Formu...
How to use Column and Columns Formula in Excel | Excel Tutorial For Beginners | Lesson - 21

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

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets