Would a pivot table help me with this?

funnyjuggler

New member
Joined
Mar 9, 2017
Messages
4
Reaction score
0
Points
0
Location
Calgary, Canada
I'm a real beginner at this stuff. Here's what I'm trying to do. My data list has 2 columns (students names + room numbers) and I want to generate a chart that lists the students in each class. I'm not sure if this can be accomplished with a pivot table, or a formula.
Excelquestion.jpg
Please point me in the right direction. Thanks
 
This can easily be done with a pivot table

Or not so easily if you're new to pivot tables.

I keep ending up with a count of the number of students in each class, but can't get a list of names. I'm not sure what I'm doing wrong. Any help would be most appreciated. Instructions, or a link to a tutorial. I've searched & searched, but unfortunately, I don't know enough to know what to search for...
 
If you want to be shown how to do this, please attach a sample Excel file.

I've moved this thread to the appropriate section.
 
Last edited:
Here's a file showing my data, the current result of a pivot table, and a manually created table that shows what I'd like the automated result to look like.

I really appreciate any help you can offer - even a nudge in the right direction.

Paul
 

Attachments

  • student list test.xlsx
    16.4 KB · Views: 18
Click button in attached.
 

Attachments

  • ExcelGuru7539student list test.xlsm
    22.5 KB · Views: 17
Back
Top