Create a Condensed List from Imported Data

[Lemmesee]

I have a sheet that is Data Imported from a txt file. I refresh this list
often, It has a bunch of blank rows.
On another sheet I need to make a list of the data from Column A of the
imported Data But I need it to be Condensed, BLANK cells Omitted.

 

[Gord Dibben]

Autofilter for non-blanks.

F5>Special>Visible cells only>OK

Copy/paste to sheet2.


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

What do you mean by condensed list - do you want to exclude blanks only or
is there another criteria as well

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Jacob Skaria]

Try the below array formula..assuming that sheet1 colA is mandatory..If not
adjust to suit

--Copy this to Sheet2 cell A1 and copy/drag to the right as required
--Also copy down as required


=IF(ROW(A1)<=COUNTIF(Sheet1!$A:$A,"?*")+COUNT(Sheet1!$A:$A),INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100<>"",ROW(Sheet1!$A$1:$A$100)),ROW(A1))),"")

If this post helps click Yes