+ Reply to Thread
Results 1 to 4 of 4

Creating a list from a table

  1. #1
    Registered User
    Join Date
    02-23-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    2

    Creating a list from a table

    Hi guys,

    I'm trying to use excel to analyse my students results in an exam paper. I have split the paper into 26 different sections and have put the childrens scores onto the spreadsheet. It has the childrens names on the left and the amount of marks the got for each questions as a decimal proportion of the available grades.

    I want to create a list of students that got 100% of the marks and a list of those that got 0%.

    EG - What I have at the moment


    Name Q1 Q2 Q3 Q4 Q5 Q6
    Kid 1 1 0 0.5 1 1 0
    Kid 2 0 0 1 0.5 1 1

    What I would like

    Q1 Q2 Q3 Q4 Q5 Q6
    Kid 1 Kid 2 Kid 1 Kid 1 Kid 2
    Kid 2

    Q1 Q2 Q3 Q4 Q5 Q6
    Kid 2 Kid 1 Kid 1
    Kid 2


    Hopefully this makes some kind of sense!

    If anyone could help, you'd be making a very sleep deprived teacher very happy!

    Thanks!
    Attached Files Attached Files
    Last edited by IsuckatXL; 02-23-2018 at 09:21 PM. Reason: formatting

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Creating a list from a table

    Inserted new sheet
    please find the attached file
    Please change the yellow colored part to 0 (zero) from 1 to get 0% marks obtained kids list
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    02-23-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    2

    Re: Creating a list from a table

    You're incredible! Thank you so much!!

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Creating a list from a table

    Hello ISuckatXL and welcome to the forum,

    I used to teach and know how it is to get stuck. If I did this problem, I'd reformat your data. See the attached where I've done an UnPivot of some example data to show you how it can help you with a better format.

    PQ Unpivot to make better data.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a list from a questionnaire table
    By Tpiper1 in forum Excel General
    Replies: 3
    Last Post: 05-23-2016, 10:11 AM
  2. [SOLVED] Creating List from Table
    By trandle in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-21-2014, 10:47 PM
  3. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  4. Need Help Creating a Table List
    By 4747daniellel in forum Excel General
    Replies: 6
    Last Post: 10-19-2011, 07:33 AM
  5. Need Help Creating a Table List
    By 4747daniellel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2011, 03:56 AM
  6. Creating a list from a large table
    By davidmarlow in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-23-2009, 05:37 AM
  7. creating a list from a table
    By sss.seg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2009, 12:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1