Hi all -
Ok, here's my problem: I have two worksheets. The 1st sheet has data
arranged like this:

Item1 SubItems Date1 Date2
subitem1
subitem2
subitem3

Item2 SubItems Date1 Date2
subitem1
subitem2
subitem3

etc

I would like to display only the item title (Item1, Item2, etc) on my 2nd
sheet without any blank spaces between them. IOW, like this:

Item1
Item2
Item3

etc

The data on sheet 1 changes often so I'd like sheet 2 to be dynamicallly
populated - IOW, by formula.

Any ideas?

thanks in advance!