Merging Rows with similar information.

Hi

I am trying to streamline an address list so as to only have one row per address. This will make postage more easier to manage. Can anyone help? I have attached a sample list.

Essentially I want to get from this:
First Name Surname Address 1 Address 2
Joe Bloggs 1 Main Street
Jane Bloggs 1 Main Street
Jack Cloggs 2 Main Street
Jim Floggs 3 Main Street
Joanne Floggs 3 Main Street
James Floggs 3 Main Street
Tom Jones 4 Main Street
Tina Smith 4 Main Street
Jeff Kloggs 5 Main Street
Janet Kloggs 5 Main Street
Ted Murphy 5 Main Street

To this:
Joe and Jane Bloggs 1 Main Street
Jack Cloggs 2 Main Street
Jim, Joanne and James Floggs3 Main Street
Tom Jones and Tina Smith 4 Main Street
Jeff, Janet Cloggs and Ted Murphy 5 Main Street

Thanks for any help!

There may be better ways, but the attached workbook seems to do the job.

Sheet2 does all the manipulation, the results are in Sheet3.

Mark.

Thanks for all your help Mark!

The entries with different surnames at the same address don't form a single address row however. Is there anything you can suggest for that?

Thanks again.

Just expanding the method I used previously gives the attached workbook, which includes everyone at each address.

Mark.