Google-sheets – Reverse QUERY in chronological order from two standalone spreadsheets

formulasgoogle sheetsgoogle-sheets-query

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)

enter image description here

Best Answer

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.

Related Topic