SOLVED

Creating a list in a chart from a spreadsheet of data

Copper Contributor

I have a spreadsheet of options for student classes that looks similar to this:

NameABCD
1XX X
2X   
3 XX 
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: 

NameItem 1Item 2Item 3
1ABD
2A  
3BC 
4C  

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

3 Replies

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;
best response confirmed by Hans Vogelaar (MVP)
Solution

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

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

 

Harun24HR_0-1709703793816.png

 

Thank you!! This worked great! @Harun24HR 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

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

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

 

Harun24HR_0-1709703793816.png

 

View solution in original post