title: Google Sheets - Ignore empty cells (JOIN & QUERY)
body: <p>I'm pretty new to googlesheets and I have a set of data that will update based on input from others and I wanted to filter data based on two matched values.</p>
  
  <pre><code>=JOIN(", ",QUERY('Form responses 1'!$D$2:$E,"SELECT D WHERE E = '"&amp;$A$2:$A&amp;"'"))
  </code></pre>
  
  <p>I have this formula and this works for my needs however it also returns a bunch of commas when there are numerous blank cells. What can I do to get it to the ignore blank cells?</p>