+ Reply to Thread
Results 1 to 4 of 4

Sorting grouped data

  1. #1
    Registered User
    Join Date
    04-18-2008
    Posts
    2

    Sorting grouped data

    Hi,
    I want to sort the following (dots are to keep text in place to simulate columns):
    B........item1
    ....................stuff i write about item 1
    ..............................more stuff
    A........item2


    I want to sort by the first column, and i would like all the "stuff" in other rows and columns below item1 to move with item1. the sorted sheet should look like:
    A........item2
    B........item1
    ....................stuff i write about item 1
    ..............................more stuff

    I tried "group"ing the cells containing B and item1 and its stuff cells, but it didn't help. Any help? See attached sheet if this isn't clear.

    thanks so much, I've spent hours on this little thing by now!
    Cosmo
    Attached Files Attached Files

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Select cells A1 to D5.
    Go to "data" "Sort"
    And Sort by column A
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    04-18-2008
    Posts
    2
    thanks for replying.

    it does sort the following properly:
    C......item1
    ...............item1 details
    ...............more item1 details
    A......item2
    B......item3

    into:
    A......item2
    B......item3
    C......item1
    ...............item1 details
    ...............more item1 details

    which appears correct, but it is only because it puts blanks rows last. This is clear if i then sort the same list , but this time descending. i get:
    C......item1
    ...............item1 details
    ...............more item1 details
    A......item2
    B......item3

    any ideas?

  4. #4
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    If you sort the same data descending you (I) get:
    (sorting by column A)

    Please Login or Register  to view this content.

+ 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