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?
Well, this isn’t really a Google Sheet forum
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
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.
@RezaRaoofi It has actually!Last digit of the formula.
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |