Cocatenate Range of Cells in a column, remove blank cells, and stack text in a cell

I am trying to find an option that will concatenate a range of 50 cells that will have text, some will be blank as well. I have come across some vba options to add a concat function but not having any luck.

Here is what I am trying to do:
L1 - "Some Text"
L2 - <blank>
L3 - <blank>
L4 - "Some More Text"
L5 - "Even More Text"
etc down to L53

in A1 I want to output:
"Some Text"
"Some More Text"
"Even More Text"

Any assistance would be greatly appreciated

Now that..was what I was looking for, took me a bit figure out the NAME error but I figured that out by placing it in a module. thank you very much debraj!!!