Excel problem-VBA code for Excel (2007)

Joined
Feb 6, 2010
Messages
1
Reaction score
0
Hi, everyone! I really hope you can help me.
I have the following problem:
2 lists of values- one is number and the other is text. I need to combine the multi cell text into a single cell if number value is identical. The problem is that number values don't repeat for the same number of times.I am having a really hard time figuring it out and would very much appreciate your help.

List is similar to this
1 A
1 B
1 C
2 D
2 E
3 F
3 G
3 H
3 I
3 J
and I would like it to result in:
1 A,B,C
2 D,E
3 F,G,H,I,J

It's like a sumif of textual values. Please help. Thanks in advance.

Bye,
T
 
Back
Top