Delete Row Prior to certain text

[jemelton]

I know VERY LITTLE about excel, but have a major problem.

I have a database that has over 70k names and occupations. Let me give an example.

Row 1 Joe Smith name adress
Row 2 carpenter
Row 3 John Smith name address
Row 4 plummer
Row 5 Tom Smith name address
Row 6 doctor
Row 7 Ron Smith name address
Row 8 Teacher
Row 9 Tim Smith name address
Row 10 Pilot



Ok, here is my question....I ONLY want to display doctors and plumbers.

If I alphabetically sort then it puts them all in alphabetical order (no correlation between name and occupation) and I have a list of alphabetical names and them when I get to the "do" I have the work doctor 1,000 times in a row.

Is there a way to delete all rows before teachers and carpenters, in other words sort in groups of 2 rows.

The only way that I am doing it now is manually going through the whole spreadsheet, searching for carpenters and teachers and manually deleting the entire row it (their name and address)


Thanks in advance, this has me bummed out!

 

[crook_101]

Hi,

Well that changes things quite a bit.......nearly 2 million records in your access db.......and it looks as though you only have the one table?? That is to be honest a bit of a mess to sort out

What I can do for you is show you how to sort your data if you get it into the format from my previous post...any use??

Ian

 

[jemelton]

The addresses are to the right of the names but I minimized the size of the column so I could share the screenshot

 

[jemelton]

There is a "help" file when I downloaded the database into access. I don't know if there would be a way to change how the date is displayed or not. I will PM you the pdf file if that is possible.


Thanks for your help!

 

[crook_101]

Hi,

It looks as though you have not followed the instructions when loading the data in Access and you will have to redo the upload into access.

I have tried to download the FAA data but cannot - I am in England so there may ne a block on it???

Sorry I can't help any further than this at this stage

If you do het the data loaded correctly into access/excel, feel free to pm me after posting and I will pick back up on this thread if you want.

Regards,
ian