i want to delete side by side cells that have the same information and leave
the single entre information cells.

cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789

cell 1,2,3,4 would be eliminated and only cell 5 would remain.

Thank you.