title: How to copy cells to new location while removing blanks?
body: <p>I am looking for a formula that reads one row of 5 cells, and fills the new row with the contents of the original row, but with the non-numeric cells removed and the rest shifted to the left:</p>
  <pre><code>Original
  
       *P*     *Q*     *R*     *S*     *T*
  *23*          8       3               2
  </code></pre>
  <p>(Note: The &quot;blank&quot; cells aren't actually blank, the only way I can get them to read correctly in a formula is if I reference them as &quot;&quot;. I am guessing this is because <code>P23:T23</code> are also references to other cells, instead of direct numbers.)</p>
  <pre><code>Result
  
       *B*     *C*     *D*     *E*     *F*
  *3*   8       3       2
  </code></pre>
  <p>I am looking for the formula to be executed in cell B3. I thought this would work:</p>
  <pre><code>=FILTER(P23:T23,NOT(ISBLANK(P23:T23)))
  </code></pre>
  <p>but, it didn't get rid of the blank cells, probably because Google Sheets doesn't think <code>P23 &amp; S23</code> are blank. Any ideas?</p>
  <p>Edit: Here's a link to the sheet: <a href="https://docs.google.com/spreadsheets/d/14M6XggpIUXNdZ5ihQ7ipim44wsn4u-ywMZCG4kYMlQY/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/14M6XggpIUXNdZ5ihQ7ipim44wsn4u-ywMZCG4kYMlQY/edit?usp=sharing</a></p>