I have a sheet that has Imported Data from a test file. I refresh this data
often. The Imported data has many Blank rows.
On another Sheet, I need to make a list of the Imported Data, Col A. I need
the list to have the Blank Cells OMITTED.
I prefer not to use AutoFilter.

Is there some way that i can do this?