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?

Column with data	Return with formula
Text	Text
	Text
Text

<tbody>
</tbody>

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.