In Google Sheets, I'm using a query to pull all my data from different tabs into one master sheet. And now I'm wondering how to sort the data according to a preset order. The order I want to sort to is something like this:

1-2 months 2-3 months 3-4 months ...up to 11-12 months

Right now when I sort 1-2months comes first, followed by 11-12 months.

Is there a simple way to sort these fields according to a preset order?

  • That sort of sort indicates that you are doing it on textual values. With no other (and better) specifications about your file I can only recommend you name them: 01-02 months 02-03 months 03-04 months ... up to 11-12 months
    – Daniele
    Aug 15, 2022 at 6:58
  • Does this answer your question? How to sort cells with text and numbers correctly
    – Tedinoz
    Aug 15, 2022 at 11:39
  • I'm not sure how to properly adapt the formula to make it work. It shows up a 'Formula Parse Error'
    – JW2022
    Aug 16, 2022 at 7:44
  • share your experience with us, post the link to your file
    – Daniele
    Aug 16, 2022 at 16:10
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Aug 17, 2022 at 0:06


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.