Results 1 to 6 of 6

Thread: Would a pivot table help me with this?

  1. #1
    Neophyte funnyjuggler's Avatar
    Join Date
    Mar 2017
    Location
    Calgary, Canada
    Posts
    4
    Articles
    0

    Question Would a pivot table help me with this?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Click image for larger version. 

Name:	Excelquestion.jpg 
Views:	28 
Size:	91.4 KB 
ID:	6539
    Please point me in the right direction. Thanks

  2. #2
    This can easily be done with a pivot table

  3. #3
    Neophyte funnyjuggler's Avatar
    Join Date
    Mar 2017
    Location
    Calgary, Canada
    Posts
    4
    Articles
    0
    Quote Originally Posted by sonjiab View Post
    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...
    Juggler - pretending he can make excel work.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,466
    Articles
    0
    Excel Version
    Office 365 Subscription
    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 by AliGW; 2017-03-12 at 08:51 AM.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Neophyte funnyjuggler's Avatar
    Join Date
    Mar 2017
    Location
    Calgary, Canada
    Posts
    4
    Articles
    0
    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
    Attached Files Attached Files
    Juggler - pretending he can make excel work.

  6. #6
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,766
    Articles
    0
    Excel Version
    365
    Click button in attached.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •