Merge cells untill we find data in the next cell....

Hi All
I am trying a macro to merge cell without losing the data until I find a next cell with the data…This merging should be pertain only for the column selected.
Is it possible to write a macro and preform this activity.

By merging do you mean concatenate the values into one cell? Otherwise I think you'd loose the data as the warning in excel says "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."