group rows

[kree8v1]

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

 

[Don]

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]

hi don, thanks, but i wasn't able to follow you. let me try to create an
illustration to , perhaps, better explain what i am trying to do.

___|_____A_____|_____B_____|______C______|_____D_____|_____E_______|
_1_|__PROJECT__|_LOCATION_|___STATUS___|___DATE____|_COMMENTS_|
_2_|___1-HU____|_Pediatrics__|___1-HOT_____|__11/11/07__|_Reconfigure_|
_3_|___________|____________|_____________|__11/12/07__|_Called Jim__|
_4_|___________|____________|_____________|__11/14/07__|_Met w/ Jim__|
_5_|___2-HU____|__Carido___ _|__3-On Hold__|__12/01/07__|__New TBD___|
_6_|___3-HU____|__ER________|__1-HOT_____|__12/02/07__|__Ned Chairs_|
_7_|___________|____________|_____________|__12/03/07__|__Called Sue_|
_8_|___________|____________|_____________|__12/04/07__|__Sent Pics__|
_9_|___________|____________|_____________|____________|____________|

In the above example, rows 3 & 4 are related to row 2. Rows7 & 8 are related
to row 6. i need to keep rows 3 & 4 with row 2, and keep rows 7 & 8 with row
6 when i sort by STATUS. i want all STATUSes to re-order, but with their
"related" rows staying with their respective "main" row (for example"main"
rows above are 2,5,6). If what you are saying to me is what will work, can
you be more explicit in what i actually enter where? thanks! Kris