Redmar
06-11-2008, 02:14 AM
I have an Excel sheet in which I store some data with some kind of Parent - Child relationship. Something like:
Parent | Child | Value1 | Value2 | .... | ValueX | TotalOfGroup
A 1 2 3 21
B 4 5 6
C 7 8 9 57
D 10 11 12
Now, I want to do some sorting over the TotalOfGroup column. In my data, the Parent data is related to the Child data, but as the sorting takes place per row, the relationship is lost.
Is there a way in Excel to group or link several rows together, so that when sorting my data, all of the rows that belong to one group are kept together while sorting?
Parent | Child | Value1 | Value2 | .... | ValueX | TotalOfGroup
A 1 2 3 21
B 4 5 6
C 7 8 9 57
D 10 11 12
Now, I want to do some sorting over the TotalOfGroup column. In my data, the Parent data is related to the Child data, but as the sorting takes place per row, the relationship is lost.
Is there a way in Excel to group or link several rows together, so that when sorting my data, all of the rows that belong to one group are kept together while sorting?