Forum Discussion
Solved
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 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.
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;
