Creating a list in a chart from a spreadsheet of data

[lleverty]

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 students' names, and the letters at the top of the columns represent the classes that are offered this quarter. 

Is there a way to take that chart and get something like this: 

Name	Item 1	Item 2	Item 3
1	A	B	D
2	A
3	B	C
4	C

in a different sheet? Essentially, I want a formula that will list the class options based on what is checked in Sheet 1. 

[#2]

sql:
//select * from who_take_classes limit 20;
cli_one_dim~who_take_classes~1;
create temp table bb as
select Name,属性,'Item '||row_number() over ( partition by Name) item from who_take_classesunion where 数量
like 'X' ;
cli_create_two_dim~bb~item~属性;
select * from bb_two_dim;

[#3 · Accepted solution]

@lleverty In excel you may try FILTER() function.

=FILTER($B$1:$E$1,B2:E2="X")

[#4]

Thank you!! This worked great! @Harun24HR