Attaching rows to one row when sorting

[Guest]

How can one Tie child rows to one parent row so that when A-Z sorting is
applied to a column the table is sorted but the child rows stay tied to there
parent row?

Note: The cells on the child rows are blank in the column used for sorting.

Thanks a Mil for any direction

 

[Guest]

There are two ways. One is to write custom macro. The second is to add a
column with an index numbers to each row. Parents and child should be
assigned the same index number. the use the index number as a sort key.

 

[Guest]

or possibly adding the parents entry in the sort column to the child entry,
sort column, and formatting it in the same color as the background....

 

[Guest]

Thanks ~ Have to research Macro's.