Hi, I've been stuck for a few hours with merging data from different cells into one. Now, I know how to do this by useing a formula, but im looking for a vba solution.

I have data generated by a macro in Cell E3 to E50. Depending on user input, cells can be blank (a macro is allready sorting the cells with data up. So its possible that only cells e3:e5 have a value. or depending on input cells e3:e15 have a value)


E
3 test 1
4 test 2
5 test 3


Now I would like to merge that input in cell E1 like this:

E
1 test 1
test 2
test 3


So each piece of data on a new line.

Im new with macro's etc., so be gentle with me

Hope someone can help