+ Reply to Thread
Results 1 to 6 of 6

Is there a way to group within groups?

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Is there a way to group within groups?

    I have data that is divided into major categories, followed by a subcategories with a subcategory within those. For example:

    2 Panera Bread
    3 Sandwiches
    4 Turkey
    4 Roast Beef
    4 Ham
    3 Soups
    4 French Onion
    4 Broccoli Cheddar
    4 Black Bean
    4 Chicken Noodle
    2 McDonalds
    3 Sandwiches
    4 Hamburger
    4 Chicken
    4 Fish
    3 Milkshakes
    4 Chocolate
    4 Vanilla
    4 Strawberry
    4 Shamrock

    I want to group all of the rows with "4" in column A, and then keep those grouped while grouping all of the rows with "3" in Column A, so that when everything is collapsed, I'm only left with a list of "2"s.

    Is this possible? Whenever I try to group the "4"s and "3"s, it ends up combining them as one big group instead of doing the tiers that I want.

    Could someone try giving me an example of how to do this with the rows between "Panera Bread" and "McDonalds"?

    Sorry for my silly example

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,706

    Re: Is there a way to group within groups?

    Perhaps what you want is to Auto Filter.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Is there a way to group within groups?

    No, I want to keep the subcategories under the correct main category - I believe autofiltering would just put them in number order?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,706

    Re: Is there a way to group within groups?

    I am confused then by your explanation. Perhaps a spreadsheet with what you have and an example of how you would like it displayed. Upload using the Go Advanced button.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Is there a way to group within groups?

    You can only group consecutive rows/columns.

    Here's an alternative idea.

    Double click on Col.A will hide all the rows have same value.
    Double click on Col.B will unhide all rows.
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Is there a way to group within groups?

    Alan's suggestion of auto filter should do what you describe.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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