In a google spreadsheet I have a query that gets data from different sheets (tabs) and pastes them into a Master sheet (tab):
=query({Sheet1!A:H; Sheet2!A2:H}, "Select * where Col1<>'' ")
Data in this Master sheet however, cannot be sorted, and I need to.
I found that if I manually copy and paste data into another sheet (tab) as "values only" I can then sort them.
So I need a query formula that does just this: automatically gets data from my Master sheet and copy and pastes them into a Master2 sheet as values only.
Any idea?