Help with Merging Two Columns based on 3rd column matching

[NancyMc91]

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 Name	Middle Name	Last Name	Suffix	Mailing Address	Mailing Address Line 2	Mailing City	Mailing State	Mailing Zip Code	Mailing Zip4
Thomas	Ryan	Legg		1 Bay St		Wrightsville Beach	NC	28480	2623
Sharon	Denise	Legg		1 Bay St		Wrightsville Beach	NC	28480	2623
Kathryn	Walters	Mcclure		1 Bayberry Pl		Wilmington	NC	28411	9205
Frank	David	Crowl		1 Cedar Is		Wilmington	NC	28409	2101
Laura	Nelson	Crowl		1 Cedar Is		Wilmington	NC	28409	2101
David	Lawrence	Rouen		1 The Isle		Wilmington	NC	28412	3278
Nancy	Gail	Rouen		1 The Isle		Wilmington	NC	28412	3278

[#2]

@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.

[#3]

@OliverScheurich Thank you very much!