Thread: Group
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline
external usenet poster
 
Posts: 48
Default Group

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