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
Bookmarks