How to convert duplicate columns into different rows for unique id

Discussion in 'Microsoft Access Queries' started by avichalbaldua, Mar 29, 2012.

  1. avichalbaldua

    avichalbaldua

    Joined:
    Mar 29, 2012
    Likes Received:
    0
    I have two attributes....First is Name and Second is Last Name...

    Now if for a particular name, eg. Gaurav there may be two last names, eg. Bansal and Gupta....

    So I want to convert it into a way that First Attribute should be Name with Gaurav, Second Attribute should be last Name with Value Bansal and Thrid attribute should be Last Name with Value Gupta...

    Kindly help!!!:(
     
    avichalbaldua, Mar 29, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Miaplacidus

    Unique Values vs Unique Records

    Miaplacidus, Sep 17, 2004, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    1,055
  2. Guest

    Convert multiple Rows into columns

    Guest, Jul 22, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    386
    Guest
    Jul 24, 2006
  3. Holly
    Replies:
    7
    Views:
    475
    guido via AccessMonster.com
    Aug 28, 2006
  4. robert_dickey@hotmail.com

    Eliminating records with duplicate fields, but not duplicate rows

    robert_dickey@hotmail.com, Sep 15, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    482
    Guest
    Sep 15, 2006
  5. Guest

    Unique Values v Unique Records

    Guest, Feb 5, 2007, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    6,645
    Guest
    Feb 5, 2007
  6. KK
    Replies:
    2
    Views:
    367
  7. Gurvinder
    Replies:
    0
    Views:
    469
    Gurvinder
    Nov 24, 2008
  8. garvic82

    Concatenate multiple rows Into one Unique Identifier

    garvic82, Feb 16, 2010, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    548
    John W. Vinson
    Feb 16, 2010
Loading...