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.

Regards,
Aaron