Sounds like you need an additional colum to keep the order of the groups.
Sounds like Project ID is the name maybe, then in the new column you can put
a formula to add 1 unless the project ID has changed , then make it equal to
one for example =IF(B3=B2,A2+1,1)

Then copy and past special the numbers to keep the order, then when you sort
, do the order colum as the secondary sort?

"kree8v1" wrote:

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