grouping rows with blank cells
In an empty column adjacent to your data, use a formula such as this (assumes
Name is in column B, starting in row 2).
=if(b2="",b1,b2)
copy the formula down for all the rows, then select all these formulas, use
EditCopy followed by EditPaste SpecialValues to convert this into a new
name column.
Next, number all the rows from 1 on up
Now sort by the new Name column and then by the new number column
"Emmweb" wrote:
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?
|