I've got a range that can be of varying size, depending on the
information entered. I'm able to strip out the blank cells so that i
am left with a range of cells that all have data in them. Now i want
to take the entries in these cells and combine them into one cell
seperated by columns. For example if i have

A
1 Word
2 Some
3 14
4 Other

then i want a cell to be Word, Some, 14, Other

All of the examples i've found through searching don't seem to be
working, any ideas?