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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Miaplacidus

    Unique Values vs Unique Records

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

    Convert multiple Rows into columns

    Guest, Jul 22, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    320
    Guest
    Jul 24, 2006
  3. Holly
    Replies:
    7
    Views:
    430
    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:
    422
    Guest
    Sep 15, 2006
  5. Guest

    Unique Values v Unique Records

    Guest, Feb 5, 2007, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    5,761
    Guest
    Feb 5, 2007
  6. KK
    Replies:
    2
    Views:
    322
  7. Gurvinder
    Replies:
    0
    Views:
    391
    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:
    521
    John W. Vinson
    Feb 16, 2010
Loading...