Results 1 to 4 of 4

Group rows together

Threaded View

LaurenR Group rows together 12-18-2009, 03:20 PM
seckert Re: Group rows together 12-18-2009, 04:48 PM
protonLeah Re: Group rows together 12-18-2009, 09:31 PM
stanleydgromjr Re: Group rows together 12-18-2009, 08:30 PM
  1. #1
    Registered User
    Join Date
    09-17-2009
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    15

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1