Mail merge format needs to be cleaned

[cduval]

I have an incredibly messy data set that I got from copying and pasting from what looks like a mail merge in word.
Essentially I need to find the data and populate into this columns:
First Name Last Name Address City State Zip Phone Email etc
The data looks like this:
[TABLE="width: 192"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]MRS ROBERTA S CHAPIN TTEE[/TD]
[TD]MR R SPENCER ALLEN TTEE[/TD]
[TD]MR HARRIS E TULCHIN[/TD]
[/TR]
[TR]
[TD]FBO CHAPIN FAMILY MARITAL TR[/TD]
[TD]R SPENCER ALLEN Q-TIP TRUST[/TD]
[TD]SCHAFER CULLEN MGT[/TD]
[/TR]
[TR]
[TD]UA DTD 07/08/80[/TD]
[TD]UA DTD 04/16/96[/TD]
[TD]548 9TH ST[/TD]
[/TR]
[TR]
[TD]19191 HARVARD AVE # 335[/TD]
[TD]541 GRACE DR[/TD]
[TD]SANTA MONICA CA 90402-2802[/TD]
[/TR]
[TR]
[TD]IRVINE CA 92612-4670[/TD]
[TD]MENLO PARK CA 94025-5724[/TD]
[TD]05 09 08[/TD]
[/TR]
[TR]
[TD]05 09 08[/TD]
[TD]05 10 04[/TD]
[TD]1HM310-451-4300 2BU310-419-7979[/TD]
[/TR]
[TR]
[TD]1HM949-856-9007 2BU[/TD]
[TD]1HM650-323-6784 2BU650-369-2995 22[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD]3FX650-366-9578 4CE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ALFONSO VASQUEZ JR, MARGARET[/TD]
[TD]MR JOEL GOLDSTEIN TTEE, DAVID[/TD]
[TD]MR ALEC MILOSLAVSKY[/TD]
[/TR]
[TR]
[TD]HELEN VASQUEZ CO-TTEES,[/TD]
[TD]OBRIEN TRUST UA DTD 04/03/03,[/TD]
[TD]MS GALINA MILOSLAVSKY[/TD]
[/TR]
[TR]
[TD]ALFONSO & MARGARET VASQUEZ[/TD]
[TD]FBO GAIL HEISER[/TD]
[TD]COMMUNITY PROPERTY[/TD]
[/TR]
[TR]
[TD]FAMILY TRUST UA DTD 05/07/03[/TD]
[TD]C/O MSI[/TD]
[TD]NUVEEN[/TD]
[/TR]
[TR]
[TD]PO BOX 738[/TD]
[TD]9229 W SUNSET BLVD STE 710[/TD]
[TD]20 BOROUGHWOOD PL[/TD]
[/TR]
[TR]
[TD]BONSALL CA 92003-0738[/TD]
[TD]LOS ANGELES CA 90069-3407[/TD]
[TD]HILLSBOROUGH CA 94010-6713[/TD]
[/TR]
[TR]
[TD]05 10 07[/TD]
[TD]06 10 09[/TD]
[TD]09 13 12[/TD]
[/TR]
[TR]
[TD]1HM760-758-9709 2BU310-323-0743[/TD]
[TD]1BU310/820-1308 2BU[/TD]
[TD]1HM650-344-1178 2BU[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MR JOSEPH DLUGOKECKI, MRS RITA[/TD]
[TD]MRS NATALIE C VOGELSANG &[/TD]
[TD]MR PETER J BLACK TTEE[/TD]
[/TR]
[TR]
[TD]L GROSS-DLUGOKECKI CO-TTEES,[/TD]
[TD]MR MICHAEL L VOGELSANG JT TEN[/TD]
[TD]PETER J BLACK TRUST[/TD]
[/TR]
[TR]
[TD]DLUGOKECKI FAMILY TRUST UA DTD[/TD]
[TD]6831 BEVIS AVE[/TD]
[TD]UA DTD 12/18/00[/TD]
[/TR]
[TR]
[TD]1/5/2000[/TD]
[TD]VAN NUYS CA 91405-3843[/TD]
[TD]2961 1ST AVE[/TD]
[/TR]
[TR]
[TD]340 HUELVA CT[/TD]
[TD]05 07 06[/TD]
[TD]SAN DIEGO CA 92103-5906[/TD]
[/TR]
[TR]
[TD]OCEANSIDE CA 92057-8404[/TD]
[TD]1HM818-901-9768 2BU323-642-5278[/TD]
[TD]05 11 10[/TD]
[/TR]
[TR]
[TD]06 11 10[/TD]
[TD]3FX 4CE[/TD]
[TD]1BU858-658-3023 2BU[/TD]
[/TR]
[TR]
[TD]1HM760-722-7252 2CE760-505-4944[/TD]
[TD][/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD]3CE619-838-9620 4HM310-510-8485[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MR ROBERT A BOTHMAN, MRS[/TD]
[TD]MRS TED VALI[/TD]
[TD]DR ROBERT M JACKSON[/TD]
[/TR]
[TR]
[TD]SHARON YVETTE BOTHMAN CO-TTEES[/TD]
[TD]MRS BARBARA VALI CO-TTEES[/TD]
[TD]MRS JUDITH JACKSON CO-TTEES[/TD]
[/TR]
[TR]
[TD]BOTHMAN FAMILY REVOCABLE TRUST[/TD]
[TD]FBO VALI FAMILY TRUST[/TD]
[TD]THE JACKSON REVOCABLE TRUST[/TD]
[/TR]
[TR]
[TD]UA DTD 12/28/99, (TCW)[/TD]
[TD]UA DTD 03/23/00[/TD]
[TD]UA DTD 11/22/91[/TD]
[/TR]
[TR]
[TD]20385 IRON SPRINGS RD[/TD]
[TD]2720 PARK AVE[/TD]
[TD]43860 10TH ST W STE 2[/TD]
[/TR]
[TR]
[TD]LOS GATOS CA 95033-9114[/TD]
[TD]LAGUNA BEACH CA 92651-2078[/TD]
[TD]LANCASTER CA 93534-4806[/TD]
[/TR]
[TR]
[TD]07 12 08[/TD]
[TD]05 09 09[/TD]
[TD]07 10 09[/TD]
[/TR]
[TR]
[TD]1HM408-353-5021 2BU408-279-2277[/TD]
[TD]1HM949-497-9440 2BU[/TD]
[TD]1HM818/368-0754 2BU661/729-4327[/TD]
[/TR]
[TR]
[TD]3CA408-639-0525 4FX408-279-2281[/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOHN A ROBINSON, THERESA P[/TD]
[TD]MR MENG HSUEH HO[/TD]
[TD]RUDOLF BRUTOCO MD &[/TD]
[/TR]
[TR]
[TD]ROBINSON CO-TTEES, ROBINSON[/TD]
[TD]MRS SHIN JUNG HO CO-TTEES[/TD]
[TD]DIANA BRUTOCO JT TEN[/TD]
[/TR]
[TR]
[TD]FAMILY TRUST UA DTD 06/06/88,[/TD]
[TD]MENG H HO & SHIN JUNG HO RVTR[/TD]
[TD]LORD ABBETT[/TD]
[/TR]
[TR]
[TD]BY WBNA AS SECURED PARTY[/TD]
[TD]UA DTD 07/22/03[/TD]
[TD]27272 VIEWPOINT CIR[/TD]
[/TR]
[TR]
[TD]2707 MASON WAY[/TD]
[TD]4183 MYSTIC VIEW CT[/TD]
[TD]SAN JUAN CAP CA 92675-1545[/TD]
[/TR]
[TR]
[TD]VISTA CA 92084-1829[/TD]
[TD]HAYWARD CA 94542-2167[/TD]
[TD]05 09 07[/TD]
[/TR]
[TR]
[TD]05 09 09[/TD]
[TD]05 12 05[/TD]
[TD]1HM949-443-1229 2FX949-443-3734[/TD]
[/TR]
[TR]
[TD]1HM760-630-0124 2BU858-740-2110[/TD]
[TD]1BU510-769-0222 2BU[/TD]
[TD]3CE949-233-3900 4CE[/TD]
[/TR]
[TR]
[TD]3FX858-586-1798 4CE858-775-5583[/TD]
[TD]3FX 4CE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DR HENRY L ABRONS[/TD]
[TD]MR DANIEL C LORTI[/TD]
[TD]MRS GLORIA J LORTI[/TD]
[/TR]
[TR]
[TD]DR LI-HSIA WANG CO-TTEES[/TD]
[TD]425 VISTA PARADA[/TD]
[TD]425 VISTA PARADA[/TD]
[/TR]
[TR]
[TD]ABRONS/WANG TRUST[/TD]
[TD]NEWPORT BEACH CA 92660-3528[/TD]
[TD]NEWPORT BEACH CA 92660-3528[/TD]
[/TR]
[TR]
[TD]UA DTD 05/28/03[/TD]
[TD]07 11 11[/TD]
[TD]07 11 11[/TD]
[/TR]
[TR]
[TD]3030 DEAKIN ST[/TD]
[TD]1HM949-759-9058 2FX949-759-4874[/TD]
[TD]1HM949-759-9058 2FX949-759-4874[/TD]
[/TR]
[TR]
[TD]BERKELEY CA 94705-1947[/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD]06 09 08[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1HM510-848-5765 2FX510-437-4187[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3OT510-308-0067 HPAG 4OT510-802-0486 LPAG[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MS DONNA LYNN STILLO TTEE[/TD]
[TD]MR PETER R JULICHER &[/TD]
[TD]MR JEFFREY BLUE[/TD]
[/TR]
[TR]
[TD]DONNA LYNN STILLO FAMILY TRUST[/TD]
[TD]MRS BETH E JULICHER JT TEN[/TD]
[TD](LORD ABBETT LRG CAP VAL)[/TD]
[/TR]
[TR]
[TD]UA DTD 04/02/98[/TD]
[TD]4623 E IMPERIAL VIEW CT[/TD]
[TD]7405 PYRAMID PL[/TD]
[/TR]
[TR]
[TD](NUVEEN MUNI FIXED)[/TD]
[TD]ROCKLIN CA 95677-4493[/TD]
[TD]LOS ANGELES CA 90046-1316[/TD]
[/TR]
[TR]
[TD]4774 PARK ENCINO LN[/TD]
[TD]08 11 09[/TD]
[TD]06 09 07[/TD]
[/TR]
[TR]
[TD]ENCINO CA 91436-3279[/TD]
[TD]1HM916-415-9323 2BU916-554-1160[/TD]
[TD]1HM323-851-7009 2BU310-865-8088[/TD]
[/TR]
[TR]
[TD]07 10 10[/TD]
[TD]3FX 4CE[/TD]
[TD]3CA310-283-8526 4BU310-865-8998[/TD]
[/TR]
[TR]
[TD]1HM818-817-0040 2BU[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MR MIKE O'SHEA &[/TD]
[TD]MR JOHN R STAHR TTEE[/TD]
[TD]MR BERNERD C KINGSBURY[/TD]
[/TR]
[TR]
[TD]MRS SHARON O'SHEA JT TEN[/TD]
[TD]JOHN R STAHR[/TD]
[TD]MRS MYRNA A KINGSBURY CO-TTEES[/TD]
[/TR]
[TR]
[TD](PORTFOLIO SERV GRP EQ 50/50)[/TD]
[TD]TRUST UA UA DTD 03/19/65[/TD]
[TD]THE BERNERD & MYRNA KINGSBURY[/TD]
[/TR]
[TR]
[TD]5889 WOODGLEN DR[/TD]
[TD]SEPARATE PROPERTY[/TD]
[TD]FAMILY TRUST UA DTD 08/18/03[/TD]
[/TR]
[TR]
[TD]AGOURA HILLS CA 91301-4629[/TD]
[TD]4639 ROXBURY RD[/TD]
[TD]4565 GREEN VALLEY RD[/TD]
[/TR]
[TR]
[TD]05 09 06[/TD]
[TD]CORONA DL MAR CA 92625-3128[/TD]
[TD]FAIRFIELD CA 94534-1367[/TD]
[/TR]
[TR]
[TD]1HM818-707-1060 2OT818-608-2718[/TD]
[TD]07 11 10[/TD]
[TD]05 10 09[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD]1HM949-760-0905 2BU[/TD]
[TD]1HM707-864-1481 2FX707-864-9109[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MRS MYRNA A KINGSBURY TTEE[/TD]
[TD]MR KIM B SNYDER[/TD]
[TD]MR LEE M KIM, MRS RUTH L[/TD]
[/TR]
[TR]
[TD]THE BERNERD & MYRNA KINGSBURY[/TD]
[TD]856 ROXBURY DR[/TD]
[TD]MINTURN-KIM CO-TTEES, LEE M[/TD]
[/TR]
[TR]
[TD]FAMILY TRUST UA DTD 04/30/92[/TD]
[TD]PASADENA CA 91104-4021[/TD]
[TD]KIM AND RUTH MINTURN -KIM[/TD]
[/TR]
[TR]
[TD]4565 GREEN VALLEY RD[/TD]
[TD]05 06 06[/TD]
[TD]FAMILY TRUST UA DTD 10/23/97[/TD]
[/TR]
[TR]
[TD]FAIRFIELD CA 94534-1367[/TD]
[TD]1HM626-798-7020 2BU626-432-5488[/TD]
[TD]19172 RED BLUFF DR[/TD]
[/TR]
[TR]
[TD]05 10 09[/TD]
[TD]3FX626-432-5489 4CE213-400-0761[/TD]
[TD]TRABUCO CYN CA 92679-1112[/TD]
[/TR]
[TR]
[TD]1HM707-864-1481 2FX707-864-9109[/TD]
[TD][/TD]
[TD]05 07 06[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD][/TD]
[TD]1HM949-858-0856 2BU[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C LAHTI, T SCHLAMME CO-TTEES,[/TD]
[TD]MS ANNE PATTERSON[/TD]
[TD]MR NICHOLAS L TETI &[/TD]
[/TR]
[TR]
[TD]S. FAMILY TRUST SEM ACCT, UA[/TD]
[TD](LORD ABBETT LRG CAP TAX BAL)[/TD]
[TD]MRS BARBARA B SASSON-TETI[/TD]
[/TR]
[TR]
[TD]DTD 09/28/95[/TD]
[TD]24311 SYLVAN GLEN RD[/TD]
[TD]JT TEN[/TD]
[/TR]
[TR]
[TD]C/O MSI[/TD]
[TD]CALABASAS CA 91302-2362[/TD]
[TD]2809 HOLLY RD[/TD]
[/TR]
[TR]
[TD]9229 W SUNSET BLVD STE 710[/TD]
[TD]05 09 06[/TD]
[TD]SANTA BARBARA CA 93105-2164[/TD]
[/TR]
[TR]
[TD]LOS ANGELES CA 90069-3407[/TD]
[TD]1HM818-222-7552 2BU818-986-4623[/TD]
[TD]06 10 10[/TD]
[/TR]
[TR]
[TD]09 13 10[/TD]
[TD]3CE818-321-1722 4CE[/TD]
[TD]1HM805-687-7286 2BU805-692-5415[/TD]
[/TR]
[TR]
[TD]1BU310/300-2905 2BU[/TD]
[TD][/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MR ROBERT D YOUNG, MRS DEBORAH[/TD]
[TD]MR RAYMOND C FREEMAN[/TD]
[TD]MR RICHARD D LOBER[/TD]
[/TR]
[TR]
[TD]YOUNG CO-TTEES, YOUNG FAMILY[/TD]
[TD]MR STEVEN K RIDGEWAY CO-TTEES[/TD]
[TD]MRS LORAINE M LOBER CO-TTEES[/TD]
[/TR]
[TR]
[TD]TRUST UA DTD 12/05/89, LORD[/TD]
[TD]FREEMAN 1976 TRUST[/TD]
[TD]LOBER FAMILY TRUST[/TD]
[/TR]
[TR]
[TD]ABBETT CONV MID CAP[/TD]
[TD]UA DTD 12/30/76[/TD]
[TD]UA DTD 04/23/93[/TD]
[/TR]
[TR]
[TD]1882 SHERIDAN AVE[/TD]
[TD]100 N HOPE AVE STE 20C[/TD]
[TD]510 SHARON RD[/TD]
[/TR]
[TR]
[TD]SAN DIEGO CA 92103-1636[/TD]
[TD]SANTA BARBARA CA 93110-2634[/TD]
[TD]ARCADIA CA 91007-7952[/TD]
[/TR]
[TR]
[TD]09 11 09[/TD]
[TD]05 12 06[/TD]
[TD]05 09 09[/TD]
[/TR]
[TR]
[TD]1HM619-291-7978 2BU619-474-8246[/TD]
[TD]1HM805-687-1173 2BU[/TD]
[TD]1HM626-446-7694 2BU[/TD]
[/TR]
[TR]
[TD]3CE619-733-5504 4CE[/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MS OI LING CHAN TTEE[/TD]
[TD]MR TIMOTHY M COLEN &[/TD]
[TD]MR IRVING RABIN, MRS VARDA[/TD]
[/TR]
[TR]
[TD]OI LING CHAN LIVING TRUST[/TD]
[TD]MS MARYALICE COLEN JT TEN[/TD]
[TD]RABIN CO-TTEES, ARIEL HANOCH[/TD]
[/TR]
[TR]
[TD]UA DTD 09/21/01[/TD]
[TD]TCW LC GROWTH[/TD]
[TD]RABIN TRUST UA DTD 12/29/81,[/TD]
[/TR]
[TR]
[TD]11224 ARROWOOD ST[/TD]
[TD]225 EDGEHILL WAY[/TD]
[TD](TCW)[/TD]
[/TR]
[TR]
[TD]ARCADIA CA 91006-5906[/TD]
[TD]SAN FRANCISCO CA 94127-1062[/TD]
[TD]298 SAN BRUNO AVE[/TD]
[/TR]
[TR]
[TD]05 07 07[/TD]
[TD]05 07 06[/TD]
[TD]SAN FRANCISCO CA 94103-5018[/TD]
[/TR]
[TR]
[TD]1HM626-444-7545 2CE626-266-0164[/TD]
[TD]1HM415-661-4148 2BU4156011709[/TD]
[TD]09 13 12[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[TD]1HM415-789-8855 2BU415-522-5700[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]3FX415-522-5701 4CE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MR IRVING RABIN, MRS VARDA[/TD]
[TD]MR IRVING RABIN, MRS VARDA[/TD]
[TD]MR IRVING RABIN, MRS VARDA[/TD]
[/TR]
[TR]
[TD]RABIN CO-TTEES, DANIEL MENAHEM[/TD]
[TD]RABIN CO-TTEES, SHIRA RABIN[/TD]
[TD]RABIN CO-TTEES, ORLEE RABIN[/TD]
[/TR]
[TR]
[TD]RABIN TRUST UA DTD 12/26/84,[/TD]
[TD]TRUST UA DTD 12/29/81, (TCW)[/TD]
[TD]TRUST UA DTD 12/21/83, (TCW)[/TD]
[/TR]
[TR]
[TD](TCW)[/TD]
[TD]298 SAN BRUNO AVE[/TD]
[TD]298 SAN BRUNO AVE[/TD]
[/TR]
[TR]
[TD]298 SAN BRUNO AVE[/TD]
[TD]SAN FRANCISCO CA 94103-5018[/TD]
[TD]SAN FRANCISCO CA 94103-5018[/TD]
[/TR]
[TR]
[TD]SAN FRANCISCO CA 94103-5018[/TD]
[TD]09 13 12[/TD]
[TD]09 13 12[/TD]
[/TR]
[TR]
[TD]09 13 12[/TD]
[TD]1HM415-789-8855 2BU[/TD]
[TD]1HM415-789-8855 2BU[/TD]
[/TR]
[TR]
[TD]1HM415-789-8855 2BU[/TD]
[TD]3FX 4CE[/TD]
[TD]3FX 4CE[/TD]
[/TR]
[TR]
[TD]3FX 4CE[/TD]
[TD][/TD]
[TD]



[/TD]
[/TR]
</tbody>[/TABLE]
there are a couple blank rows before the next set of names begin.
Is there a quick way for me to copy and paste (transpose) the first row after each blank row set?