Reverse QUERY in chronological order from two standalone spreadsheets

Question

I have a report that pulls data from a separate sheet using a QUERY. The report has a "notes" column (not part of the query) so users can add notes associated with a particular row. This solution works perfectly when the query is in chronological order but fails (query data doesn't stay grouped with user notes) when I query in reverse chronological.

I'm looking for a solution that will display the data in reverse chronological order while remaining grouped with the associated user entered notes.

Any suggestions are greatly appreciated.

QUERY STATEMENT

=query(data!A2:BK,"select B, C, D, E, F, G, H, I, J, O, P, Q, R, S, T, BA, A where J = 'Industry Tour *approval required' order by A desc",false)

Answer 1

You might stitch two ranges together and control the sort order with something like:

=QUERY({A1:F10,G1:I10},"select * order by Col1 desc")

changing desc to asc to suit.

Answer 2

=TRANSPOSE(QUERY(QUERY({TRANSPOSE(B2:G5);
                        TRANSPOSE(H2:I5)}, 
           "select *", 0), 
           "select Col4, Col3, Col2, Col1", 0))

Answer 3

In the case described there are two simple tables that aren't coupled, so the solution is to couple them. To do this add key to both tables, then join them and finally display them as you want. The easier way is to keep the first query unchanged (keep the chronological order) and to add a new query or sort function that returns the data in reverse chronological order.