How to query for row range in Google Sheets?

Question

21.8k views Asked by orschiro At 07 September 2017 at 10:16

Is it possible to use Google Sheets' =query to select only a specific row range, e.g. rows 38 to 57 of sheet1?

There are 2 answers

TheMaster On 07 September 2017 at 13:45

Not directly. But, If you transpose them, then you could use them.

   =QUERY(TRANSPOSE(38:57),"Select *")

**Max Makhrov** · Accepted Answer · 2017-09-07 11:15:14

Max Makhrov On 07 September 2017 at 11:15 BEST ANSWER

=QUERY(FILTER(A1:B,ROW(A:A)>=4,ROW(A:A)<=8),"select Col1, Col2")

The query syntax has no option to use rows in where clause. I suggest using query + filter