Sorting received data from query-CodePudding

I have a Google Sheet where in sheet B C D E data gets entered and exported to sheet E via a query.

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

I don't 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 which need to be sorted.

I tried 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:

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)