Multiple Variables in a Single Column to a Dummy Variable Matrix

I have an excel file with 1 just column. The thing is this column has multiple fields in each cell, all of which are separated by a comma.

Example would be:
A,B,C,D
A,B,C
A,B
A
A,D

I wanted to have a dummy variable matrix such that it would look something as attached.

Dummy Data.JPG

With your data in A2 down and A,B,C,D in B1:E1

in B2

=--(ISNUMBER(SEARCH(B$1,$A2)))

Copy across and down

Works perfectly. Thanks a lot!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.