List multiple rows in one column without blanks using a formula

[Tim_Excel_]

Hi forum,
I'm looking for a formula that will list a number of rows in a sheet into a single column, while excluding any blank cells. I've found a formula that lists a single column, but I need to list multiple rows:

=IFERROR(INDIRECT("A"&SMALL(IF(LEN($A$1:$A$20)=0,"",ROW($1:$20)),ROW(A1))),"")

An example of what I need:

	A1	B1	C1	D1	E1	F1	G1	H1	I1
1	n1		n1	n2		n3		n4	n5
2	n2		n6		n7			n8
3	n3
4	n4
5	n5
6	n6
7	n7
8	n8

<tbody>
</tbody>