Results 1 to 18 of 18

Concatenate cells and delete duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Spokane, WA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Concatenate cells and delete duplicates

    I have an excel 2007 spreadsheet that lists
    items on multiple rows for the same customer.

    Each sheet will list anywhere from 25 to 100 individual customers.

    I need to identify the duplicates, concatenate
    the "Items" to a single cell on the first row, and
    delete the duplicate rows. eg:

    Cust #| Item
    1 | A
    1 | B
    1 | C
    2 | B
    2 | E
    3 | A
    3 | C
    3 | E

    The result should look like:

    Cust# | New Item
    1 | A, B, C
    2 | B, E
    3 | A, C, E

    Can this be done? Thanks!
    Last edited by VBA Noob; 04-03-2009 at 01:52 AM.

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