+ Reply to Thread
Results 1 to 3 of 3

merging people who live in same address into the one field and delete duplicates

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    merging people who live in same address into the one field and delete duplicates

    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

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: merging people who live in same address into the one field and delete duplicates

    Hi IM Shadi,

    Welcome to the forum.

    Please upload a sample workbook.. I guess if you have data properly arranged, you can create a pivot table with the help of some concatenation and this can solve your issue to some extent but not sure unless I see your workbook.. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: merging people who live in same address into the one field and delete duplicates

    probably better to upload a book as an example to be honest. then people can work more efficently on if.

    the problem looks like it will be ok to solve but hard without a book to know for sure
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1