Trying to Consolidate using Excel - Need to Concatenate

Trying to Consolidate using Excel - Need to Concatenate

I have a mail list that I need to merge the duplicate addresses together
and concatenate the names. Example below:
Name Street_Address
--------- ----------------
JohnDoe 444 Elm Street
JaneDoe 444 Elm Street
BillyBob 456 Birch Street
BugsBunny 999 Maple Street
BabsBunny 999 Maple Street
I would like to merge the duplicates like so:
Name Street_Address
------------------ ----------------
JohnDoeJaneDoe 444 Elm Street
BillyBob 456 Birch Street
BugsBunnyBabsBunny 999 Maple Street
I've tried using the consolidate feature but you don't get the option for
concatenate. Thanks for your help!