Sorting subset of column headings

Question

Level 1

4 points

Sorting subset of column headings

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

Posted on Nov 2, 2012 10:24 AM

Reply

Answer 1

Best reply

Jerrold Green1

Level 7

30,210 points

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

Reply

Answer 2

captainKCF Author

Level 1

4 points

Nov 2, 2012 12:08 PM in response to Jerrold Green1

Thanks! That is a really terrific feature. Now I am stuck once again: I know how to sort columns, but am having trouble sorting by a row. So I want the titles sorted. I went to more options, but only see sorting by column, am I missing something? Thanks!

Reply

Answer 3

Nov 2, 2012 2:17 PM in response to captainKCF

Numbers only sorts by column

Reply

Answer 4

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

Reply