How to Filter Out Blank Cells using ARRAYFORMULA (Google Sheets)

Question

In this example, 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.

Does anyone know how I can tell ARRAYFORMULA to ignore blank cells?

Answer 1

See if this would help;

=query('Input Data Feeds'!F:I, "where F <>'' ")