Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google query result without header

The following formula produces a 2-row result for me: a header row and a data row

=QUERY(A1:I7,"select B,C where A=1",-1)

I would like to have a single-row result: just data, without header.

I found similar questions, but none of the answers are applicable to my question, because I do not use SUM() or other aggregate functions.

Google SpreadSheet Query: Can I remove column header? https://productforums.google.com/forum/#!topic/docs/0CPyUKPSl5E https://productforums.google.com/forum/#!topic/docs/UEYtMBH_Wnk

like image 391
Andrej Adamenko Avatar asked Sep 19 '25 18:09

Andrej Adamenko


1 Answers

I found an answer here:

=QUERY(A1:I7,"select B,C where A=1 label B '',C ''",-1)
like image 120
Andrej Adamenko Avatar answered Sep 23 '25 11:09

Andrej Adamenko