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(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)