title: Excel Dynamic Array to include blank cells
body: <p>Is there a way to keep the empty cells when filtering data with the <code>FILTER()</code> function? As for now, Excel is outputing the value 0 when an empty cell occurs.</p>
  <p>For Example if this is a table in Excel (named tbl):</p>
  <pre><code>Name  | City  | Street
  ----------------------
  name1 | city1 | street1
  name2 | city1 |
  </code></pre>
  <p>The function:</p>
  <pre><code>=FILTER(tbl;tbl[City]=&quot;city1&quot;)
  </code></pre>
  <p>Returned as above but with &quot;0&quot; instead of an empty cell.</p>