I would like to merge cells in column A when the adjacent vertical cells are
the same. For example:

Col A
Row1 CX457
Row2 AG925
Row3 AG925
Row4 AG925
Row5 RB639
Row6 RB639

In this case A2, A3 & A4 would be merged, A5 & A6 would be merged. Is there
a way to do this automatically?

Thanks,
Joe M.