Concatenate cells using a varying identifier in a different field

Compiling a Voter list. Each voters information is recorded in basic fields (ie. First Name, Last Name, Address, City, State..ect ect.) Each member of a voting household is listed separately even though having the same address. I need to combine the first name fields of records that have the same address. I'm new to the forum. The forum is not allowing me to attach a sample sheet at this time. But here is what I can do.
CRAP IT LOOKED BETTER BEFORE I PREVIEWED IT.

Any solutions or guidance
is greatly appreciated.

Thanks

Last Name First Name Address City Zip (RA) State (RA)

SHIFFIS RUSTY 10262 FARM ROAD 2240 WALTON 78000 IL
JILSON VALERIE 1035 WASHBURN PRAIRIE RD WALTON 78000 IL
SHRUCK MEGAN 106 CHURCH ST WALTON 78000 IL
BEANS CONNIE 107 W PINEVILLE RD WALTON 78000 IL
LINDE GERALD 1106 2ND ST WALTON 78000 IL
LINDE JANIS 1106 2ND ST WALTON 78000 IL
WENDRIX JAMES 1215 STATE HWY 90 WALTON 78000 IL
WENDRIX MELISSA 1215 STATE HWY 90 WALTON 78000 IL
WENDRIX DORTHY 1215 STATE HWY 90 WALTON 78000 IL
WENDRIX JOHNIE 1244 STATE HWY 90 WALTON 78000 IL
SLACK-WENDRIX LOUISE 1244 STATE HWY 90 WALTON 78000 IL
BARNER GREGORY 128 N OLD WIRE RD WALTON 78000 IL
STEPHENSON CONNIE 1305 FARM RD 2272 WALTON 78000 IL
STEPHENSON WILLIS 1305 FARM RD 2272 WALTON 78000 IL

RESULTS NEEDED
Last Name First Name Address City Zip (RA) State (RA)
SHIFFIS RUSTY 10262 FARM ROAD 2240 WALTON 78000 IL
JILSON VALERIE 1035 WASHBURN PRAIRIE RD WALTON 78000 IL
SHRUCK MEGAN 106 CHURCH ST WALTON 78000 IL
BEANS CONNIE 107 W PINEVILLE RD WALTON 78000 IL
LINDE GERALD & JANIS 1106 2ND ST WALTON 78000 IL
WENDRIX JAMES, MELLISSA & DORTHY 1215 STATE HWY 90 WALTON 78000 IL
WENDRIX JOHNIE 1244 STATE HWY 90 WALTON 78000 IL
SLACK-WENDRIX LOUISE 1244 STATE HWY 90 WALTON 78000 IL
BARNER GREGORY 128 N OLD WIRE RD WALTON 78000 IL
STEPHENSON CONNIE & WILLIS 1305 FARM RD 2272 WALTON 78000 IL

Oh yeah it did attach