Non Blank List

[Legacy 436357]

Hello,

I have a list in E2:E10 that has some blanks. How can I return a non-blank list starting in E12?

Thanks for the help,
XJ

 

[Momentman]

Here's one way I like

Book1
	A
1
2	Try
3	Not
4
5	To
6	Be
7
8	Bkank
9
10	But
11
12	Try
13	Not
14	To
15	Be
16	Bkank
17	But
Sheet5

Cell Formulas
Range	Formula
A12	{=IFERROR(INDEX($A$1:$A$10,SMALL(IF($A$1:$A$10<>"",ROW($A$1:$A$10)-ROW($A$1)+1),ROWS($1:1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.