Hello Experts,
I had to repost this question as my original Sept 24th's posting crashed
along with everyone else's postings.

How do you, in code, group according to similar names, then consolidate
all of the row's "X"'s into a single line? Such as;
1) Group each similar name within Column A;
2) Start with the last line within that group;
3) Copy and Paste Special, Skip Blanks, onto the next row up
4) Then, go back down to the last row within the group;
5) Delete last row within the group
6) Loop; until all multiple names become just one row per name.

To Illustrate:
[Column]
A B C D E
Bill X X
Bill X X X
Bill X X
Sue X
Sue X
Bob X X
Bob X X

Should become:
A B C D E
Bill X X X X X
Sue X X
Bob X X X X


Thanks in advance,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!