How to convert duplicate columns into different rows for unique id

avichalbaldua avichalbaldua is offline

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!!!

« Query to duplicate a record with one field updated | MS Access Form update »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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