Search code examples
google-sheetsrowgoogle-query-language

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

Solution

  • Instead of labeling column names as blanks using '', you can omit all headers like this:

    =QUERY('Все'!A1:I7,"select B,C where A=1", 0)

    By removing headers from the input, you drop the headers from the output.