title: How to find all non blank cells in an array of cells?
body: <p>I have some data in <strong>$A$1:$D$50</strong>. How can I put all non blank cells into a single column (say <strong>E</strong>) using a formula (regular or array one). All other examples I've found were about finding blank cells in a single column or a row.</p>
  
  <p>Thanks</p>