LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV file with 13space characters in blank cells Jim May Excel Discussion (Misc queries) 2 December 6th 05 09:22 PM
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
Blank cells represented in area charts cdoughty Charts and Charting in Excel 2 August 6th 05 06:02 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
How to delete blank rows John Mansfield Excel Discussion (Misc queries) 3 April 27th 05 11:48 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"