I have a parts list that I would like to highlight the column and run a macro
that would merge all the simular values together.
Values in each cell. I would like to highlight the column and where each
value is the same make one cell (Merge).

123
123
123
345
345
567
789
789



Regards,
Aaron