A formula to copy and past data between sheets as values only

by otto   Last Updated January 13, 2018 18:03 PM

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?

Tags : google-sheets

Related Questions