How do I fill one column with what is in another column with empty cells removed?

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

This is a good start, but I need Excel to get rid of blanks without me having to do anything manually like sorting the column. Any ideas? Thanks.

Hahaha! That sounds like you are asking me if I am ready to go on a dangerous adventure. I have no VBA experience, but if you give me the general idea, a couple of helpful websites and the help of great folks like yourself at this forum, I think I could muddle through.

So yes, please let me know how. Thank you.