- 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
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