QUERY Course for Google SHEETS - Lesson 3 - Sorting with ORDER BY

In this video we learn how to sort our tables with the QUERY function and, specifically, with the ORDER BY command.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below

[@RajeshKumarPV]

Thank you. I was looking to sort on a query and was stuck. This helped. Thanks a lot

[@practicalsheets]

Excellent!

[@rafalvarezsevilla]

YESSSSSS THATS EXACTLY WHAT I NEEDED!!!

[@practicalsheets]

Excellent!

[@camioneur]

Spot on, gracius

[@practicalsheets]

Thank you!

[@rafalvarezsevilla]

is there a way to auto sort columns without the need to copy the whole table? i get market data, and its sorted from oldest to most recent date. its no problem to sort it by recent date, as thats just 2 extra columns, but i have like 50 other columns that i would like to move with it, so the recent date is always at the top, and the rest moves down day by day, as i need to input a lot of data into the recent date cells...

[@jasonstewart7983]

Thanks. I'm glad you showed the trick of "WHERE A IS NOT NULL" - I was having that problem of empty rows.

[@practicalsheets]

Excellent
It is a very common case
Regards!

[@okon1624]

fantastic 🤩

[@practicalsheets]

Thank you!

[@kipinsane1]

Please tag me I’m trying to sort with dropdown so when I change a Dropbox it moves the entire row up or down based on column and where it is.

[@practicalsheets]

Hi!
I don´t understand fully what you want to achieve
Could you explain further?
Kind Regards

[@user-vd2rl3bt9k]

How i can order by date if my date in this format dd.mm.yyyy?

[@alexandrateixeiraf]

Did you solve this? I have the same problem

[@practicalsheets]

Does Sheets recognize your date column as a date? or as a text. If you order it using order by, it orders alphabetically?
Kind Regards