Thread: Create a Condensed List from Imported Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote