Thread: group rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kree8v1 kree8v1 is offline
external usenet poster
 
Posts: 2
Default group rows

help,
I am entering data for management of a project:

ROW1:
Column1 = Project ID
Column2 = Project location
Column3 = Project status
Column4 = Date of comments
Column5 = Comments

ROW2:
Column1 = BLANK
Column2 = BLANK
Column3 = BLANK
Column4 = (new) Date of (new) comments
Column5 = (New) Comments

and on and on, adding many more Projects and their multiple lines of dates
comments.

I want to be able to sort by the STATUS column. When I do this, all the
multiple rows that lie benaeth the 1st Row of the Project, do not remain
adjacent to their initial Project 1st Row. Only the rows like the ROW1
example above sort.

I have looked into GROUPING of rows but can't seem to get this to work for
how I need it.

I need to be able to clump those rows together and stay together for a sort
that will use the data of the clump's 1st row.

help! thanks in advance