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
    Messages:
    1
    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. Guest

    Convert multiple Rows into columns

    Guest, Jul 22, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    245
    Guest
    Jul 24, 2006
  2. Holly
    Replies:
    7
    Views:
    352
    guido via AccessMonster.com
    Aug 28, 2006
  3. 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:
    354
    Guest
    Sep 15, 2006
  4. KK
    Replies:
    2
    Views:
    271
  5. Gurvinder
    Replies:
    0
    Views:
    335
    Gurvinder
    Nov 24, 2008
Loading...

Share This Page