How can I: Fill one column with what is in another column with empty cells removed?

[fbarbie]

Hello everyone,

In one column, I have comments to a survey that looks like this:

Its great
Its stinks
(empty cell)
It needs work
(empty cell)
I see no problem

I would like these comments to be automatically populated in another column but with the empty cells removed so that it will look like this:

Its great
It stinks
It needs work
I see no problem

How can I do this? And for extra credit, how can I have each comment put in quotation marks (“ “)?

Thanks as always for sharing your expertise.

Frank