Sort column list by header

[suprchic66]

I'm a very basic Excel user, but I'm sure there is a way to accomplish this goal. I'm not even sure what to call it in searching, so I apologize if this has already been posted elsewhere.

I have a list of data, separated by commas. I need to sort that data into different columns, based on referencing the header row.


Original List:
1 A,B,D,G,J
2 B,D,F,J
3 A,D,L

Desired Result:
A B C D E F G H I J K L
as row headers, with the value listed if it is present in that row. All the A's into one column, and the B's into one column, etc.

I know I can take the comma-separated list and break it into columns, but how to get the values all into different columns? Any help would be greatly appreciated.

[azumi]

Assumed your data in Cell A1 and down, put in B1:

=TRIM(MID(SUBSTITUTE($A$1,",",REPT(" ",LEN($A$1))),(COLUMNS($A$1:A1)-1)*LEN($A$1)+1,LEN($A$1)))

and copied to the right, hope it works....