complie a list of text fields

[ricks]

How can I complie a list of all the rows in a column if the rows contain text?
For example, in column C, I have the following data for each row:

1 foo
2 <blank>
3 bar

I want a formula to return the contents of the text column (with line
break/wrap):

foo
bar


Thanks