Skip navigation

Sorting subset of column headings

322 Views 4 Replies Latest reply: Nov 2, 2012 2:35 PM by Jerrold Green1 RSS
captainKCF Calculating status...
Currently Being Moderated
Nov 2, 2012 10:24 AM

Hello!

 

I have exported a csv from edmodo (grade school social networking site).  It has grades from assignments and quizzes.  The first two columns are the names of the students and then the top row, after the first 2 columns, are the assignment titles.  I would like to keep the kids names on the left, but have all columns after the first 2 be sorted alphabetically according to assignment name.  This way I can see trends and such.  Is this possible?  Ive attached an examples.

 

Thanks!

 

-Josh

 

https://www.dropbox.com/s/uypilcfcgtjr33g/EdmodoGradesExported.numbers

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Nov 2, 2012 11:54 AM (in response to captainKCF)

    KC,

     

    If you don't care which kid's name is associated with a particular row of scores, why not just remove the names from the table? You can save them off to the side as a separate two-column table. To do this, Select the first two column labels (A and B) and drag them off the main table and drop them on a blank part of the Sheet.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (12,560 points)
    Currently Being Moderated
    Nov 2, 2012 2:17 PM (in response to captainKCF)

    Numbers only sorts by column

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Nov 2, 2012 2:35 PM (in response to captainKCF)

    KC,

     

    To rearrange the columns, grab a column, or group of columns, just as you did with the Name columns. Then, rather than drag them off the table, drag them across the table and drop them where you want them to be. As you move across the table the borders will change to double lines to indicate where the dragged column will be dropped.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.