+ Reply to Thread
Results 1 to 4 of 4

Identify duplicate coloum A cells, and merge their row and text in

  1. #1
    Calla212
    Guest

    Identify duplicate coloum A cells, and merge their row and text in

    I have exported data from a database into a delimited CSV. file and opened
    it in excel.

    The database has a field where you can enter a description for an item. It
    appears that if the description has a return or is over 32 characters it
    creates a new field. On the worksheet you will see duplicate cells in column
    A (barcode #'s) with different descriptions in column B.

    This makes sorting the worksheet very difficult and almost impossible for
    reporting or mantainancing to import back into the database.

    Is there a way to identify all the duplicate cell A'S and then have their
    corresponding cell B's merge and still retain their text?






  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186
    do you want to do this with vba or on the worksheet?
    regards

  3. #3
    Calla212
    Guest

    Re: Identify duplicate coloum A cells, and merge their row and tex

    Sorry don't know vba is.

    But I need it all in the worksheet.

    "tony h" wrote:

    >
    > do you want to do this with vba or on the worksheet?
    > regards
    >
    >
    > --
    > tony h
    > ------------------------------------------------------------------------
    > tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
    > View this thread: http://www.excelforum.com/showthread...hreadid=527814
    >
    >


  4. #4
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186
    I'll give you some pointers and see how you get on.

    when you import the data the first thing to do is join together the data.
    if the key is in column A insert a blank column at B with the data then in C.

    In column B use a formula like =if(A2<>A1,C2,C1&" "&C2) on line 2 then copy this down. This should build up the strings. Now get rid of the formulae in column B by copying Column B and doing a paste special values. You can now delete column C

    Next you need to get rid of the incomplete rows so insert a column A. on line 1 use the formula =B1=B2 and copy this down The lines you want to keep are flagged FALSE. do a copy col A and paste special values (to get rid of the formulas)

    you can then sort column A and delete the TRUE lines.


    hope this works for you

    regards

+ 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