Hi all, this is my problem
I have random data and lots of it. We are wanting to create a new sheet where the duplicates are removed and extra colums are added for the recipients who live at the same address. This way the mail will only go to one household. Example
Last First Title Address
Sample Dimitra Miss 12 Barkly St FITZROY NORTH VIC 3068
Doe John Mr 32 Dryh St NORTH MELBOURNE VIC 3051
Shedbe Helen Mrs 43 Bazza St Carlton VIC 3053
Skarbek Sophie Miss 10 pomrst St RICHND SA 3111
Doe Sandy Mr 32 Dryh St NORTH MELBOURNE VIC 3051
Sample Sam Mr 12 Barkly St FITZROY NORTH VIC 3068
I would like to end up with
Last First Title Address First1 Title1 First 2 Title 2
Sample Dimitra Miss 12 Barkly St FITZROY NORTH VIC 3068 Sam Mr
Doe John Mr 32 Dryh St NORTH MELBOURNE VIC 3051 Sandy Doe
Shedbe Helen Mrs 43 Bazza St Carlton VIC 3053
Skarbek Sophie Miss 10 pomrst St RICHND SA 3111
please help
Bookmarks