Home > Mobile >  Sorting recieved data from querry
Sorting recieved data from querry

Time:01-04

Hi all i have a google sheet where in sheet B C D E data gets enterd and exported to sheet E via query.

but it sorts it per sheet and not mix them in order.

i dont want a Date order of sheet B then sheet C,

i need it that 1-1-23 on sheet D is in front of 31-12-2022 from sheet B

this is the query formula i use now

=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null",0)

Col1 is the column with the dates in it witch need to be sorted

i stried sorting via the Sort A-Z method that is not working i also tried to add Sorty By Col1 as shown below

=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null",0,Sorty By Col1)

example sheet https://docs.google.com/spreadsheets/d/1gQUkJUW8ChWj59vtDu64rI1ozZjY6b5ABmzns6lgF9o/edit?usp=sharing

CodePudding user response:

try:

=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null ORDER BY Col1 DESC",0)

  • Related