CODEWITHSUNDEEP
google-sheets
user3076837
user3076837

Reputation: 1

QUERY function places blank rows from bottom of original spreadsheet at the top of the new sheet

It seems pretty straight-forward. I query the columns and ask it to sort the results in asc or desc order by a single column. The problem is that I cannot add any additional rows to my original spreadsheet or it places blank rows at the top of my Query sheet. Here is the formula I am using:

=QUERY('Jose 2013 Master'!B1:V500; "select B,O,E,S,T,U,V,G ORDER BY G asc", 1)

Any suggestions?

Upvotes: 0

Views: 1753

Answers (1)

Zig Mandel
Zig Mandel

Reputation: 19835

you need to filter those out, as in "where G<>'' "

Upvotes: 1

Related Questions