+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Can Excel Groupby without totals - treeview look

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Vail, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    83

    Post Can Excel Groupby without totals - treeview look

    One customer has many Notes (or Comments)
    Need to pull data, and have the comments at the end (right hand side column)
    Notes can be zero to many.
    Trying to prevent many rows with the same information - just to show the notes.

    Can Excel use groupby or some other format to collaspe the last column, and let the user click to expand?

    Alternative, the notes could be concatinated into one column.


    Can Excel provide a groupby collasped view of records that behave like a tree view?
    The data would represent:
    A B
    ID1 Note1
    ID1 Note2
    ID1 Note3
    ID1 Note4
    ID2 Note1
    ID2 Note2

    When I attempt a group by, it seems to put a Total in place.

    A B
    ID1 Note1, Note2, Note3, Note4

    ID2 Note1, Note2

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Can Excel Groupby without totals - treeview look

    Perhaps a Pivot Table would be the answer. It groups nicely. Do you need a tutorial on Pivot Tables? Look here

    http://www.datapigtechnologies.com/ExcelMain.htm

    Scroll down about 1/3 of the page.

    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

+ 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