title: How to Filter Out Blank Cells using ARRAYFORMULA (Google Sheets)
body: <p>In <a href="https://docs.google.com/spreadsheets/d/1N3s6r4ZDSzMmpkmlodzH9uaTBSaQ9NYRnjnL38OX5OI/edit?usp=sharing" rel="nofollow">this example</a>, I am capturing data from three sources on the web and trying to display that data cleanly in the sheet called 'Output' (Sheet1). I am using a very simple set of ARRAYFORMULA functions that copy the entire column from Sheet2 into Sheet1.</p>
  
  <p>Does anyone know how I can tell ARRAYFORMULA to ignore blank cells?</p>