Results 1 to 9 of 9

Table format Conversion

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Dayton
    MS-Off Ver
    Excel 2007
    Posts
    23

    Table format Conversion

    I have a table with two columns "code" and "dates". There are duplicates in the code column but each duplicate has an corresponding unique date. I want to eliminate the duplicate codes and have the unique date values put next to each other under a single row for a given code word.

    Example:
    as 98
    as 76
    as 76
    bc 54
    de 32
    rf 54

    I want a table as:

    as 98 76 56
    bc 54
    de 32
    rf 54

    I have also attached a sample sheet for further reference. Any help is appreciable.

    Thanks
    Attached Files Attached Files
    Last edited by ramanan256; 09-22-2011 at 05:57 PM.

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