W1nter_mute
Level 1 (0 points)

Q: Is there a way to group rows&columns in numbers 3.2?

Hi guys!

 

Can you please suggest a way to group rows and columns in groups in Numbers 3.2? I used this feature in Excel, and it is extremely useful when you deal with big amount of data.

 

I heard that there was categorization feature in Numbers, but it looks like it was gone in 3.2.

OS X Mavericks (10.9.2)

Posted on May 4, 2014 6:50 AM

Close
W1nter_mute

Q: Is there a way to group rows&columns in numbers 3.2?

  • All replies
  • Helpful answers

  • by SGIII,

    SGIII SGIII May 4, 2014 7:47 AM in response to W1nter_mute
    Level 6 (10,796 points)
    Mac OS X
    May 4, 2014 7:47 AM in response to W1nter_mute

    Categorization is gone in Numbers 3.  To view subsets of your data you can, however, use filters.

     

    add-filter.png

     

    SG

  • by W1nter_mute,

    W1nter_mute W1nter_mute May 4, 2014 9:08 AM in response to SGIII
    Level 1 (0 points)
    May 4, 2014 9:08 AM in response to SGIII

    Filter is something different. It can be useful, but I need grouping - ability to roll up different rows under one.

     

    It looks like there is no way to group rows in Numbers.

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 May 4, 2014 2:05 PM in response to W1nter_mute
    Level 7 (30,001 points)
    May 4, 2014 2:05 PM in response to W1nter_mute

    That's called Categories in Numbers. Numbers V3 was built without that capability, but Numbers V2 has it. Downgrade and you're good to go.

     

    Jerry

  • by SGIII,

    SGIII SGIII May 4, 2014 5:41 PM in response to W1nter_mute
    Level 6 (10,796 points)
    Mac OS X
    May 4, 2014 5:41 PM in response to W1nter_mute

    Are you referring to the  "Group and Outline" functionality by that name in Excel.  Or perhaps tables. 

     

    You can come close the the capability of pivot tables in Numbers by using SUMIFS and COUNTIFS:

     

    SUMIFS.png

     

     

    A big advantage is that you can then use the results in the summary table to create charts, something you can't do with the old Numbers categories.

     

    And filtering will easily allow you to show one "group" at a time.

     

    I thought the old Numbers categories were sometimes convenient, but in the "nice but not necessary" category. There are other ways to accomplish the same effect that aren't too difficult and work across platform.

     

    SG

  • by W1nter_mute,

    W1nter_mute W1nter_mute May 5, 2014 8:26 AM in response to SGIII
    Level 1 (0 points)
    May 5, 2014 8:26 AM in response to SGIII

    Yep, I meant "Group and Outline" functionality from Excel.

     

    Thank you for your suggestions, but it looks like I should think about purchasing of MS Excel for Mac for my tasks.

  • by Darmok,

    Darmok Darmok Aug 28, 2016 1:47 PM in response to SGIII
    Level 1 (4 points)
    Aug 28, 2016 1:47 PM in response to SGIII

    That was very helpful SGIII