sunefromsmørum
Level 1 (10 points)
Mac OS X

Q: sort - not columns - but rows in 3.01

How to sort - not columns - but rows - in 3.01?

iMac, Mac OS X (10.6.4)

Posted on Dec 21, 2013 2:49 AM

Close
sunefromsmørum

Q: sort - not columns - but rows in 3.01

  • All replies
  • Helpful answers

  • by Yellowbox,

    Yellowbox Yellowbox Dec 21, 2013 3:09 AM in response to sunefromsmørum
    Level 6 (10,535 points)
    Mac OS X
    Dec 21, 2013 3:09 AM in response to sunefromsmørum

    Hi sune,

     

    As far as I know, Numbers has always had the ability to sort rows. Numbers 3.0.1 has lost the abilty to sort only some rows within a table, but there are ways to work around this. In the meantime, we must wait for Apple to re-instate Multi-column and range sort (and other features):

     

    http://support.apple.com/kb/HT6049

     

    Please reply with a description of what you are trying to do.

     

    Regards,

    Ian.

     


  • by sunefromsmørum,

    sunefromsmørum sunefromsmørum Dec 21, 2013 3:16 AM in response to Yellowbox
    Level 1 (10 points)
    Mac OS X
    Dec 21, 2013 3:16 AM in response to Yellowbox

    Thank you Ian,

     

    Let's say I want to sort e.g. rows 11 - 14 - based on dates in column 1.

     

    In Numbers 09 - it was simple - I just chosed the rows and sort in the organizer.

     

    All the best,

    Sune

  • by Yellowbox,Helpful

    Yellowbox Yellowbox Dec 21, 2013 4:14 AM in response to sunefromsmørum
    Level 6 (10,535 points)
    Mac OS X
    Dec 21, 2013 4:14 AM in response to sunefromsmørum

    Hi Sune,

     

    While we all wait for Apple to put this feature back in another update of Numbers 3, try this:

     

    Screen Shot 2013-12-21 at 10.55.29 pm.png

     

    You want to sort rows 11-14 (as an example). Add a Colour Fill to row 15 as a guide for later.

    Select rows 11-14. Click and *hold* on any Row Reference Tab. You will see the selected rows appear to 'lift'. Drag those rows away from Table 1 to a blank part of the 'canvas':

     

    Screen Shot 2013-12-21 at 10.59.25 pm.png

     

    and they will form a new table. Sort this table.

    Then select all rows of Table 2, and Copy.

    Click on Table 1. Select the colour filled row where you want to insert (row showing 23 Jun 2013 in this example).

     

    Menu > Insert > Copied Rows.

     

    Screen Shot 2013-12-21 at 11.07.29 pm.png

     

    Not as easy as Numbers 2.3 Reorganize Panel, but a workaround.

     

    If you frequently resort the same rows, consider placing them in their own table.

     

    Regards,

    Ian.

  • by sunefromsmørum,

    sunefromsmørum sunefromsmørum Dec 21, 2013 4:20 AM in response to Yellowbox
    Level 1 (10 points)
    Mac OS X
    Dec 21, 2013 4:20 AM in response to Yellowbox

    Thank you Ian - again,

     

    That's a smart, creative and tricky solutuion!

    I can now see what creative thinking can do - thank you.

     

    Thank you - all the best regards,

    Sune

  • by Yellowbox,

    Yellowbox Yellowbox Dec 21, 2013 4:29 AM in response to sunefromsmørum
    Level 6 (10,535 points)
    Mac OS X
    Dec 21, 2013 4:29 AM in response to sunefromsmørum

    Hi Sune,

     

    Happy Numbering!

     

    Regards,

    Ian

  • by Badunit,Helpful

    Badunit Badunit Dec 21, 2013 5:37 AM in response to Yellowbox
    Level 6 (11,705 points)
    iTunes
    Dec 21, 2013 5:37 AM in response to Yellowbox

    Another feature that I wish they changed for the worse was the ability to select all the rows/columns of a table and insert them into another table. You used to be able to lift rows from a table, do what you needed with them as another table, then put lift them and put them back into the original table without having to copy/"insert copied rows" or delete a leftover table. Now you cannot lift every row/column of a table so you cannot simply slide the rows back where they came from as you could in '09.

  • by Barry,

    Barry Barry Dec 21, 2013 12:25 PM in response to Badunit
    Level 7 (32,697 points)
    iWork
    Dec 21, 2013 12:25 PM in response to Badunit

    @Badunit

     

    Can you

    • lift the rows you want to work on from the original table
    • do what you need with thes rows as another table
    • add a row or two to this 'other' table so that the lifted and worked on rows are no longer the 'whole' table
    • lift the altered rows (now only 'part' of the table)
    • put them back in the original table.
    • select what's left of the 'other' table and press delete

     

    Not quite as convenient, but is it workable?

     

    Regards,

    Barry

  • by Badunit,

    Badunit Badunit Dec 21, 2013 1:23 PM in response to Barry
    Level 6 (11,705 points)
    iTunes
    Dec 21, 2013 1:23 PM in response to Barry

    Barry,

     

    First let me clarify my original statement. I don't "wish they changed for the worse". I must have typed something else first (such as "I wish they would put back in") and changed it. It should be "...they changed for the worse..."

     

    Yes, you can add a row, put the other rows back where they belong, then delete the leftover table.  That's what I've been doing but it is two extra steps that should be unnecessary. It worked better in '09.