How to return the text that is in one column, in another column, ignoring zero values or blanks

[Porcupine_]

I have a column that has some cells filled with text, and some blank. I want to create a separate column that returns only the cells filled with text, ignoring blanks. I've shown what I mean in a table below. Is anyone able to help with this?

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Column with data[/TD]
[TD]Return with formula [/TD]
[/TR]
[TR]
[TD]Text[/TD]
[TD]Text[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Text[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Text[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much

 

[Porcupine_]

Ah perfect - I think I missed the cntrl, shift enter step - now it is working perfectly.

What does Control, Shift, Enter do?

Thank you very much!

 

[My Aswer Is This]

Ah perfect - I think I missed the cntrl, shift enter step - now it is working perfectly.

What does Control, Shift, Enter do?

Thank you very much!

Glad it's working. I really do not know answer about what it does.
I just know some formulas require it.