Hi I have got a long excel sheet with many categories.
For example,
A B C
1 Name Category Amount
2 T1 X 1000
3 T1 Z 1000
4 T1 Y 1000
5 T2 X 100
6 T2 Z 100
7 T2 Y 100
8 T2 W 100
How do i get to,
A B C
11 T1 X,Y,Z 1000
12 T2 X,Y,Z,W 100
Thanks in advance
Z
For example,
A B C
1 Name Category Amount
2 T1 X 1000
3 T1 Z 1000
4 T1 Y 1000
5 T2 X 100
6 T2 Z 100
7 T2 Y 100
8 T2 W 100
How do i get to,
A B C
11 T1 X,Y,Z 1000
12 T2 X,Y,Z,W 100
Thanks in advance
Z