I have a simple task that I can't figure out.
I have rows of data with two columns per row:
A C
A M
A Q
B R
B F
C D
C J
and I want to select those cells and have it change them to:
A C, M, Q
A
A
B R, F
B
C D,J
C
Column 1 is sorted. A,B,C are not the real values of my data but you get the idea. There might be 20 A rows, 30 B rows, etc. I want to process through them and concatenate the Column 2 values for every unique Column 1 value.
Could anybody help me with this coding? I keep trying and I keep failing.
I have rows of data with two columns per row:
A C
A M
A Q
B R
B F
C D
C J
and I want to select those cells and have it change them to:
A C, M, Q
A
A
B R, F
B
C D,J
C
Column 1 is sorted. A,B,C are not the real values of my data but you get the idea. There might be 20 A rows, 30 B rows, etc. I want to process through them and concatenate the Column 2 values for every unique Column 1 value.
Could anybody help me with this coding? I keep trying and I keep failing.