Group rows together

Hello!

This is my second time posting- thank you always for all of your help! Here is what I'm trying to do.

I have a 2000 page Word document that I need to sort through. My initial solution was to copy and paste it into Excel (see attached "before" file for a section of the copied results). As you can see, it copies all of the info into Column A.

I then separated the data into separate columns, and deleted those that were not important to me. This is where I get stuck. I only need the groups of information that correspond to the "Z- New Constr." entry in the new Column A (See the attached "during" file for an example of where I get stuck). The groups are between dashed lines- that comes with the copy from Word.

Is there any way to get to my "after" file without going through and manually deleting all non-New Construction entries? I tried to sort by Column A and it obviously doesn't move all of the corresponding rows.

This file only starts with 6 entries- my real file has many more than that! Any help you can provide would be really appreciated!

Thanks so much!

Lauren

See attached.

Copy the formulas in new colums D and E down for your entire data set.
Copy / Paste Values for these two columns to hard-code the results
Sort on column E
Delete the rows you don't want
Sort on column D to get the remaining data back to it's original order.

Hope this helps

SAE