How to use query in Google spreadsheet to select column instead of row? -
please, need !!!
i tried
=query(a1:e6, "select * d = 'yes'", 0)
it select rows in column d has value 'yes'.
my question is: how select columns in row 2 has value 'yes'. tried:
=query(a1:e6, "select * 2 = 'yes'", 0)
but not work :(
to query, need double transpose, or use alternative filter.
=transpose(query(transpose(a1:e6),"select * col2 = 'yes'",0))
or
=filter(a1:e6,a2:e2="yes")
Comments
Post a Comment