Create a Condensed List from Imported Data
 

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.

Create a Condensed List from Imported Data
 

Autofilter for non-blanks.

F5SpecialVisible cells onlyOK

Copy/paste to sheet2.


Gord Dibben MS Excel MVP

On Thu, 15 Oct 2009 15:52:01 -0700, Lemmesee
wrote:

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.

Create a Condensed List from Imported Data
 

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

"Lemmesee" wrote in message
...
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.

Create a Condensed List from Imported Data
 

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(Shee t1!$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
---------------
Jacob Skaria


"Lemmesee" wrote:

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.