Copy data from diff row to diff column

Closed

psri - Nov 4, 2008 at 06:13 AM
psri - Nov 4, 2008 at 09:46 PM

Hi,

Need a small help in VBA. Please refer below structure:

Column1 Column2
A Apple
B Apple
A Bat
A Apple
B Bat
A Cat

What I need is:

Wherever there is A in Column1, the unique 1st value in Column2 agains the same should come in a different column, say Column3. Again, the 2nd value should come in Column4, and so on.
e.g. Column1 has A 4 times, out of which Apple is twice. I want Apple to come on Column3, and Cat on Column4.

Any help in this regard shall be highly appreciated.
Thanks

Copy data from diff row to diff column
Oracle date diff - Guide
Transfer data from one excel worksheet to another automatically - Guide
Tmobile data check - Guide
Saints row 2 cheats - Guide
Display two columns in data validation list but return only one - Guide

1 response

Answer 1 / 1

eurospc Posts 6 Registration date Sunday October 19, 2008 Status Member Last seen May 15, 2009
Nov 4, 2008 at 08:39 AM

hello buddy just try to see if you can get what you are trying to do there:

http://office.microsoft.com/en-us/excel/default.aspx

psri
Nov 4, 2008 at 09:46 PM

Hi
Thanks for the reply.
I tried but could not locate any help in VBA for my above prob.
Please let me know if you have come across any page which has the solution to this.
Thanks

Similar discussions

Converting rows of data in notepad to columns

AMD data change update new data to DMI

Unlock safe folder without losing any data

How to copy the Column value into Rows

Similar discussions

Subscribe To Our Newsletter!