=IF(ISERR(SMALL(IF(names<"",ROW(INDIRECT("1:"&ROW S(names)))),ROWS($1:1))),"",INDEX(names,SMALL(IF(n ames<"",ROW(INDIRECT("1:"&ROWS(names)))),ROWS($1: 1))))

ctrl+shift+enter, not just enter
copy down


"Mike Pearson" wrote:

I have a column of names ie:

A
1 Bill
2 John
3
4 Mike
5 Rex
6 Stu

On another sheet, I want to have it list all the names on that list down a
column, but I want it to not carry over any blank cells. So on sheet2 it
would look like this:

A
1 Bill
2 John
3 Mike
4 Rex
5 Stu

Do you know how I can make that happen? Thank you in advance.