title: How to use query in Google spreadsheet to select column instead of row?
body: <p>Please, need your help !!!</p>
  
  <p>I tried </p>
  
  <pre><code>=query(A1:E6, "select * where D = 'Yes'", 0)
  </code></pre>
  
  <p>it will select the rows which in column D that has value 'Yes'.</p>
  
  <p>My question is: how to  select the columns which in row 2 that has value 'Yes'. I tried:</p>
  
  <pre><code>=query(A1:E6, "select * where 2 = 'Yes'", 0)
  </code></pre>
  
  <p>but it does not work :(</p>