Condensing list with blank cells (formula)

Hi,   Can anyone help with a formula that can be used to analyze a column of data and return a condensed list of the same data in the column but removing the blank cells? The formula must be compat...