TechSpot

Deleting Duplicate Information in Excel / Access

By pianoko
Jul 13, 2007
Topic Status:
Not open for further replies.
  1. I have a list of nearly 400 mailing lists along with their owner. I have created a mail merge document to send an email to the list owners about upgrading to a new system. The file was generated by list name, not by owner name. So I have owners with 15 lines because they have 15 different lists. When I do the mail merge, that owner will receive 15 emails, instead of 1 with the 15 lists listed. What I want is to consolidate the file and organize it by owner name so that there is the same number of rows as there are owners, and all the owners lists appear in the same cell under the "lists" column.

    I will demonstrate....

    What I have now.....

    Code:
    User1     user1email     list1
    User1     user1email     list2
    User1     user1email     list3
    .........


    What I want is...

    Code:
    User1     user1email     list1
                             list2
                             list3
    I thought access may have a tool that could do this easily, but I have zero knowledge in access. Do you have any suggestions?
     
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.