I have several spreadsheets with as many as 4000 rows apiece in which I need
to combine certain fields. Here's an example of the spreadsheet I have:

| A. ID | B. Name | C. Add Type | D. Add 1 | E. City | F. State | G. ZIP
---------------------------------------------------------------------------------------
1.| 1000 | Joe | Home | 101 Main | OKC | OK |
77777
2.| 1001 | Bob | Home | 201 2nd | OKC | OK |
77777
3.| 1001 | Bob | Mail | 100 12th | OKC | OK |
77771
4.| 1003 | Jim | Home | 222 Main | EDM | OK |
77703
5.| 1005 | Sue | Home | 301 Ave | EDM | OK |
77703
6.| 1005 | Sue | Mail |400 East | OKC | OK
| 77777

What I basically need to do is find the employees (with the same ID #) that
have both a home and a mailing address, and either delete the Home address,
or combine the rows in a way in which only the mailing address remains, so I
can mail merge the spreadsheet without getting two envelopes for each
employee that has both a mailing and a home address. I could do this
manually, but with multiple spreadsheets and over 4000 employees, it gets
pretty tedious and mistakes tend to be made. Anyone have any suggestions?