+ Reply to Thread
Results 1 to 3 of 3

Getting Duplicate Row values into Columns

  1. #1
    Registered User
    Join Date
    06-26-2007
    Posts
    2

    Getting Duplicate Row values into Columns

    Ok... I may not have an accurate title on this..

    Here is what I need to do.. Take the following
    HTML Code: 
    item#     cart#         Description
    1021	   432	     INSTRUMENT WIPE
    1021	   4526	     INSTRUMENT WIPE
    10219	   313	     MICROFIBRILLAR COLLAGEN SHEET
    10219	   4499	     MICROFIBRILLAR COLLAGEN SHEET
    10219	   4621	     MICROFIBRILLAR COLLAGEN SHEET
    
    
    And convert to the following
    Item         description                                         cart#s
    1021         INSTRUMENT WIPE                          432   4526
    10219        MICROFIBRILLAR COLLAGEN SHEET            313   4499   4621
    I would like to put the cart numbers in separate columns.

    I need the easiest way to accomplish this as I have about 20,000 rows to convert to this format.

    Thanks for your help...

  2. #2
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Pivot Table

    You could use a pivot table, refer to "transpose data" question

    http://www.excelforum.com/showthread.php?t=625776

    Hope it may help.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,487
    w/o PT
    Please Login or Register  to view this content.

+ 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