QUERY - Select a Range of Multiple Columns in Google Sheets

How to get QUERY function in Google Sheets to select a range of columns?

#query #googlesheets #advanced

[JMC]

I'm following your lessons from France. Your pronunciation for a non native English listener and your teaching techniques are brilliant! I have so much improved my skills at work. I thank you so much!

[nssdesigns]

I binge watch ALL your videos. You are the goTo guy for advanced sheets stuff. This helps a lot!

[eugeniab]

so cool, as always! thanks for doing this!

[GM]

The Choosecols function, which was not available at the time of this video, can make the process easier. You can use Sequence inside Choosecols to select a range of columns. For example, if you want columns 3-7 and 10-15, the formula would look like this: =choosecols(query(TEXT!A1:T, "select *", 1), sequence(5, 1, 3), sequence(6, 1, 10)). Forgivingly, it also works if you swap the rows and columns in the Sequence; i.e., in a Choosecols function, sequence(1, 5, 3) works the same as sequence sequence(5, 1, 3). If you have a long string in your Query, then putting it in a Let function and inserting some returns makes it simpler.

[tecnoideas]

Greetings from Paraguay. You are the best teacher ever. The content of your channel is liquid gold! I just asked my sister if she wants to marry you...

[garychadwick]

Really useful for large data sets. Thanks as always!

[robertmaluka]

I could never do query function. I just did filter function. Now I am starting with query function, Thanks again your videos so helpful, I learn so much.

[TheHeatingEngineer]

A great video, well presented and very informative. Well done and thanks.

[anvi]

Thank you for the new trick to use in the query formula. Am I the only one who gets excited when I see a new video posted by you? 🙂

[tgtylec]

Just what I was looking for. Many Thanks!

[HagridThoughts]

Thanks for putting these great videos together! They’re always helpful and spark new ideas.

I was wondering if there is a way to dynamically select multiple columns by using checkboxes

[alexmi]

Thanks a lot! I had same issue early today! 😀

[sukanandnarula]

I never comment on videos - but I have been using your video as guides and have managed to automate a lot of my business. I want to sincerely thank you for your videos. You are doing an awesome job and a great service. Always look forward to new videos. I was wondering if you have the time; could you do a video on google sheets and whatsapp integration - for example - like sending whatsapp message from sheets - or even better can take a message from whatsapp and pull corresponding data from the sheet and send back message to whatsapp.
Anyways keep up the good work!

[Maestr]

Never used SEQUENCE, awesome to learn, thanks!
As always, my 0, 02 $ just to give some alternatives:

1. you can use MATCH to find the col number:
=QUERY({TEXT!A2:G};"Select Col"&MATCH(A1;TEXT!1:1;0)&", Col"&MATCH(B1;TEXT!1:1;0)&", Col"&MATCH(C1;TEXT!1:1;0);1)
you need to set the data array to skip the headers and the query sheet will need to have column names in it to look for.
this can be very powerful in combination with a validated list for the column headers

2. you can replace the ARRAYFORMULA with just a join (both formula's below amount to the same):
=ARRAYFORMULA("SELECT " &JOIN(", "; "Col"&Sequence(1;10)))
="SELECT Col" & JOIN(", Col";SEQUENCE(1;10))

[diaa]

Thank you very useful, Can we have the same idea with a dynamic range of rows.

[osvaldodsj]

Muito obrigado por compartilhar seu conhecimento!

[marcosrs]

Amazing trick! Seriously, one of the most brilliant! Your channel is the best one.

[edwinrondina]

Hi sir, you're the best teacher as always! Is there a way that I could select, unselect and select all data in a certain range dynamically thru data validation? Hope you may read my comment. Thank you very much sir!

[johndarenvaldez]

That is awesome buddy! You just solved my problem today. Thank you so much. New subscriber here from the Philippines.

[NewToneProducer]

Is there a way to make the columns that are selected based on a condition? For example, if I want to ignore columns that are blank, can I make it so it only selects columns that have text or numbers in them?