PC Review

Thread Tools Rate Thread

How to convert duplicate columns into different rows for unique id

New Member
Join Date: Mar 2012
Posts: 1
      29th Mar 2012
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!!!
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert duplicate rows into unique rows in a Table? KK Microsoft Access Queries 2 7th May 2008 02:40 PM
Changing columns into rows and rows into columns =?Utf-8?B?Ymhvd2s=?= Microsoft Access Getting Started 1 6th Jun 2007 12:41 AM
Convert columns to rows: create duplicate rows based on column val =?Utf-8?B?Q2FycmllUg==?= Microsoft Access 3 30th Aug 2006 07:07 PM
How can i convert the rows into columns and columns into rows? =?Utf-8?B?WWFzc2Vy?= Microsoft Excel Worksheet Functions 1 7th Aug 2005 07:38 AM
convert rows to columns and columns to rows helpful sql Microsoft ASP .NET 0 19th May 2005 07:03 PM




All times are GMT +1. The time now is 01:21 PM.