Merge and compare cells using macro

S

saul.japson

Here's my problem. I have a column populated with values. I want the
macro to compare a1 with a2 and if they have same value, to merge them.
Then it would check a3 and compare it with the previous cell and merge
if the same value. If it does not have the same value, then go the
next cell and compare. The result would be multiple merged cells in
the column with the same value. Does anyone have a macro or know how
to do this?
 
Top