I currently need to get the data from an entire column of cells, and add them to column. The thing is, the data in the column is not a straight line, there are blank cells in between data entrys in the column.

Basically, i need to copy the data values only from the cells that contain data, where it is put in one neat straight line in another column.


Hopefully this makes sense...