Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV file with 13space characters in blank cells | Excel Discussion (Misc queries) | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
Blank cells represented in area charts | Charts and Charting in Excel | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) |