R
Ranjith Kurian
I have Name column with corresponding single alphabets in a different column
for each rows
exmaple:
Name
MON Q D C B N
TUE T
WED H U I T R E J L
THU A S L K V X Z W Q I L
I could like to have macro code to combine each column data to a single cell
as shown below, the Column ‘A’(Name) will always have a name but the other
columns are not fixed (it can increase or decrease)
Example:
Name
MON Q,D,C,B,N
TUE T
WED H,U,I,T,RE,J,L
THU A,S,L,K,V,X,Z,W,Q,I,L
for each rows
exmaple:
Name
MON Q D C B N
TUE T
WED H U I T R E J L
THU A S L K V X Z W Q I L
I could like to have macro code to combine each column data to a single cell
as shown below, the Column ‘A’(Name) will always have a name but the other
columns are not fixed (it can increase or decrease)
Example:
Name
MON Q,D,C,B,N
TUE T
WED H,U,I,T,RE,J,L
THU A,S,L,K,V,X,Z,W,Q,I,L