Gathering Data into a List

Giganews Newsgroups
Subject: Gathering Data into a List
Posted by:  chris (anonymo…@discussions.microsoft.com)
Date: Fri, 31 Oct 2003

Lets say that I have a group of cells ten columns by three
rows with some of the cells containing text.  Which cells
have text and which are blank will change every now and
then.

I want to create a column that gathers all data from the
above group of cells and puts them into a list.  Blank
cells will not be displayed and the column will gather the
data for the first cell from A1, the second from A2, the
third from A3, the fourth from B1, etc... unless of course
the referenced cell is blank, in which case it would
gather the next bit of text.

How do I do this?

Replies