How to Select Multiple Columns using Query function

To select multiple columns using the QUERY function in Google Sheets, you'll need to use the "Select" clause followed by the specific columns you want to select, separated by a comma.

Here's a step-by-step guide:

1. Ensure you have data in your sheet. For this example, let's consider the following dataset:

2. Determine the columns you want to select. For instance, if you want to select the "Name" and "City" columns, you will use the QUERY function to do so.
3. Use the QUERY function in a new cell where you want the results to appear. In this case, let's use cell E1. The formula will look like this:

=QUERY(A1:C4, "Select A, C")

4. Press Enter to execute the formula. You should now see the "Name" and "City" columns displayed in columns E and F:

Remember to adjust the range (A1:C4) to match your actual data range, and replace A and C with the columns you want to select.

Example

In this example, we have a dataset in the range A1:C4, and we want to select the Name and City columns:

=QUERY(A1:C4, "Select A, C")

The result will be: