Table of Contents
Google Sheets Query is a function which allows you to query data based on criteria and retrieve certain columns of data from a spreadsheet. To select multiple columns, you can use the “SELECT” keyword and list out the column names separated by a comma. You can also use the asterisk (*) to select all columns in the spreadsheet. The results of the query will be displayed in the output range.
You can use the following syntax to select multiple columns using the Google Sheets query function:
=query(Range, “select A, B, C“, 1)
This particular query selects columns A, B, and C in a dataset and the 1 specifies that there is 1 header row at the top of the dataset.
The following examples show how to use this function in practice with the following dataset:
Example 1: Select Multiple Columns
We can use the following syntax to select all rows from the Player and Team columns:
Example 2: Select Multiple Columns Based on Condition
We can also select multiple columns based on some condition.
For example, we can use the following syntax to select the Player and Team columns where the Team is equal to Mavericks.
Example 3: Select All Columns
We can use the following syntax to select all of the columns in the dataset:
