CODEWITHSUNDEEP
google-sheetsspreadsheet
Jerry
Jerry

Reputation: 107

Google Sheets Query - Issue grouping rows into the header row

Whenever I query a large amount of data, it bunches up several rows into the header row row.

I've tried

=QUERY('Keywords-Raw'!A:O,"SELECT A,B,G,L,O WHERE L MATCHES '"&A1&"'",1)

which removes the header, but I need the header.

I've also tried

=QUERY('Keywords-Raw'!A:O,"SELECT A,B,G,L,O WHERE L MATCHES '"&A1&"' OFFSET 1"), but this only skips a row that I'll need.

enter image description here

I don't want it to be grouped like that. I want it to be like the rest of the rows.

Upvotes: 0

Views: 280

Answers (1)

JohnA
JohnA

Reputation: 1107

Did you mean to write "MATCHES" not "="

=QUERY('Keywords-Raw'!A:O,"SELECT A,B,G,L,O WHERE L = '"&A1&"'",1)

Also, if you do not want column labels, use the LABEL keyword

=QUERY('Keywords-Raw'!A:O,"SELECT A,B,G,L,O WHERE L = '"&A1&"' LABEL A '', B '', G '', L '', O '' ",1)

Upvotes: 2

Related Questions