|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
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?