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