Hi there,

For whatever reason when our system compiles data into Excel 2003 it creates
a worksheet that looks like this (for example):

Purple Purple Purple Purple
Purple Green Green
Green
Blue Blue Blue Blue Red Red Red
Yellow Yellow Yellow Yellow
Yellow Orange
Orange Orange
Brown Brown Brown Brown Teal Teal Teal
Black Black Black Black Grey Grey Grey

I am hoping someone might be able to help me create a macros to combine the
duplicate rows together so that it looks like this:

Purple Purple Purple Purple Green Green Green
Blue Blue Blue Blue Red Red Red
Yellow Yellow Yellow Yellow Orange Orange Orange
Brown Brown Brown Brown Teal Teal Teal
Black Black Black Black Grey Grey Grey

While I would love a macros that could repair an entire worksheet (~25,000
rows) as you can see from my example, there is no discernible pattern between
single and duplicate rows. I would be happy with just a simple macros that
can combine the two rows and maybe I could attach it to a hotkey.

Any help would be greatly appreciated!