Dear Team, Any idea about it? I am using QUER...

(Etwo Cargo) #1

Dear Team, Any idea about it? I am using QUERY on google sheet as

=QUERY(TGDSS;“SELECT A,B,C,D,E,F,G,H,O,P,Q,R,S,T,U,V,W,X,Y,Z WHERE P > 0”;1)

and i am getting wanted columns from target sheet. But some rows are empty even they are filled at target sheet. What could be the reason?

(Reza Raoofi) #2

Well, this isn’t really a Google Sheet forum :wink:

I think the selected range in QUERY() function needs to include column headers. support.google.com - QUERY function - Docs Editors Help QUERY function - Docs Editors Help support.google.com

(Gregory Diana) #3

One presumes TGDSS is A1:Z and ROW1 is a

header row as noted by header =1 as last parameter in query statement.

I think you mean some cells are empty not rows. Clear the formatting in the new area to which the select data is being copied.

(Etwo Cargo) #4

@RezaRaoofi It has actually!Last digit of the formula.