View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emmweb
 
Posts: n/a
Default grouping rows with blank cells

I have a worksheet with data like:
Name ID Attribute
Attribute
Name ID Attribute
Attribute
Attribute
Name ID Attribute

Each Name and ID can have multiple attributes (lines), up to about 20 lines
per person. Only the first line for each person shows the Name and ID.

Is there an easy way to "group" the lines together in such a way that I
could sort on Name or ID and not lose the Attributes (in the correct order)
that go with them?