title: Return only filled cells in Google Sheets QUERY
body: <p>I have this formula in my sheet:</p>
  
  <p><code>=query('Character Analysis'!$H62:$L83,"select H,I,J,K,L where H is not null order by L DESC",0)</code></p>
  
  <p>Only the first two of the source rows have data in them, but on the sheet with the query formula it appears to be pulling all the rows in the range, even the blank ones. If I type something in the 3rd row on the query formula sheet, it gives me an error saying "Array result was not expanded because it would overwrite data in ________." But it doesn't need that room because there are only two rows of data in the query result.</p>
  
  <p>I tried adding the "is not null" language in hopes that it would limit the returned result to only filled cells, but it's not working.</p>
  
  <p>How can I tell my query to only pull data from filled cells in the source range?</p>