How to convert duplicate columns into different rows for unique id

A

avichalbaldua

Joined
Mar 29, 2012
Messages
1
Reaction score
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!!!:(
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
VB 2008, how to do installation for small program with a lot of files 9
Query that will look for duplicate in two tables. 3
How to convert duplicate rows into unique rows in a Table? 2
Store Employee ID in table, Display User Name in form 1
How do I separate first and last names into two columns? 2
Formula, Macro, or VBA code to find and insert 3
How can I combine 2 columns into 1, Excel? 2

Top