Creating a list in a chart from a spreadsheet of data

I have a spreadsheet of options for student classes that looks similar to this: Name A B C D 1 X X   X 2 X       3   X X   4     X   The numbers represent the ...