No one answered. Maybe we cannot quite work out what is in the worksheet
Please add * at the end of each row as seen in worksheet
I do wish these newsreaders let us display cells better
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Atom Oaks" <Atom wrote in message
...
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!