Help with Merging Two Columns based on 3rd column matching

%3CLINGO-SUB%20id%3D%22lingo-sub-2822206%22%20slang%3D%22en-US%22%3EHelp%20with%20Merging%20Two%20Columns%20based%20on%203rd%20column%20matching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2822206%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning.%26nbsp%3B%20I%20have%20addresses%20of%20spouses%20that%20are%20on%20two%20different%20rows.%20I%20want%20to%20merge%20them%20into%20one%20row%20so%20ultimately%20I%20can%20create%20a%20mail%20merge%20for%20letters.%26nbsp%3B%20So%20if%20the%20mailing%20address%20in%20column%20E%20is%20the%20same%20for%20row%202%20and%203%20then%20I%20want%20to%20merge%20the%20First%20Name%20on%20row%203%20with%20row%202%20so%20it%20will%20say%20Thomas%20%26amp%3B%20Sharon%20Legg%26nbsp%3B%20-%20Can%20you%20help%3F%26nbsp%3B%20I%20attached%20the%20file.%3C%2FP%3E%3CTABLE%20width%3D%221130%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22111%22%3EFirst%20Name%3C%2FTD%3E%3CTD%20width%3D%22135%22%3EMiddle%20Name%3C%2FTD%3E%3CTD%20width%3D%22150%22%3ELast%20Name%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESuffix%3C%2FTD%3E%3CTD%20width%3D%22242%22%3EMailing%20Address%3C%2FTD%3E%3CTD%20width%3D%2265%22%3EMailing%20Address%20Line%202%3C%2FTD%3E%3CTD%20width%3D%22169%22%3EMailing%20City%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMailing%20State%3C%2FTD%3E%3CTD%20width%3D%2265%22%3EMailing%20Zip%20Code%3C%2FTD%3E%3CTD%20width%3D%2265%22%3EMailing%20Zip4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EThomas%3C%2FTD%3E%3CTD%3ERyan%3C%2FTD%3E%3CTD%3ELegg%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20Bay%20St%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWrightsville%20Beach%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28480%3C%2FTD%3E%3CTD%3E2623%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESharon%3C%2FTD%3E%3CTD%3EDenise%3C%2FTD%3E%3CTD%3ELegg%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20Bay%20St%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWrightsville%20Beach%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28480%3C%2FTD%3E%3CTD%3E2623%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKathryn%3C%2FTD%3E%3CTD%3EWalters%3C%2FTD%3E%3CTD%3EMcclure%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20Bayberry%20Pl%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWilmington%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28411%3C%2FTD%3E%3CTD%3E9205%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFrank%3C%2FTD%3E%3CTD%3EDavid%3C%2FTD%3E%3CTD%3ECrowl%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20Cedar%20Is%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWilmington%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28409%3C%2FTD%3E%3CTD%3E2101%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELaura%3C%2FTD%3E%3CTD%3ENelson%3C%2FTD%3E%3CTD%3ECrowl%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20Cedar%20Is%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWilmington%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28409%3C%2FTD%3E%3CTD%3E2101%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDavid%3C%2FTD%3E%3CTD%3ELawrence%3C%2FTD%3E%3CTD%3ERouen%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20The%20Isle%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWilmington%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28412%3C%2FTD%3E%3CTD%3E3278%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENancy%3C%2FTD%3E%3CTD%3EGail%3C%2FTD%3E%3CTD%3ERouen%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%20The%20Isle%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWilmington%3C%2FTD%3E%3CTD%3ENC%3C%2FTD%3E%3CTD%3E28412%3C%2FTD%3E%3CTD%3E3278%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2822206%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2823897%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Merging%20Two%20Columns%20based%20on%203rd%20column%20matching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2823897%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1178450%22%20target%3D%22_blank%22%3E%40NancyMc91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(E2%3DE3%2CCONCATENATE(A2%26amp%3B%22%20%26amp%3B%20%22%26amp%3BA3%26amp%3B%22%20%22%26amp%3BC2)%2C%22%22)%3C%2FP%3E%3CP%3EI%20would%20insert%20an%20additional%20range%20and%20enter%20this%20formula%20in%20F2%20(in%20my%20example)%20and%20copy%20formula%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2823905%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Merging%20Two%20Columns%20based%20on%203rd%20column%20matching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2823905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1178450%22%20target%3D%22_blank%22%3E%40NancyMc91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(E2%3DE3%2CCONCATENATE(A2%26amp%3B%22%20%26amp%3B%20%22%26amp%3BA3%26amp%3B%22%20%22%26amp%3BC2)%2C%22%22)%3C%2FP%3E%3CP%3EI%20would%20insert%20an%20additional%20column%20and%20enter%20this%20formula%20in%20F2%20(in%20my%20example)%20and%20copy%20formula%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning.  I have addresses of spouses that are on two different rows. I want to merge them into one row so ultimately I can create a mail merge for letters.  So if the mailing address in column E is the same for row 2 and 3 then I want to merge the First Name on row 3 with row 2 so it will say Thomas & Sharon Legg  - Can you help?  I attached the file.

First NameMiddle NameLast NameSuffixMailing AddressMailing Address Line 2Mailing CityMailing StateMailing Zip CodeMailing Zip4
ThomasRyanLegg 1 Bay St Wrightsville BeachNC284802623
SharonDeniseLegg 1 Bay St Wrightsville BeachNC284802623
KathrynWaltersMcclure 1 Bayberry Pl WilmingtonNC284119205
FrankDavidCrowl 1 Cedar Is WilmingtonNC284092101
LauraNelsonCrowl 1 Cedar Is WilmingtonNC284092101
DavidLawrenceRouen 1 The Isle WilmingtonNC284123278
NancyGailRouen 1 The Isle WilmingtonNC284123278
2 Replies

@NancyMc91 

=IF(E2=E3,CONCATENATE(A2&" & "&A3&" "&C2),"")

I would insert an additional column and enter this formula in F2 (in my example) and copy formula down.