I have two worksheets -- Lets say ws1, ws2.

Data in ws1 looks like

column1
data1
data2
data3

Data in ws2 looks like

column1 column2
data1 value1
data1 value2
data1 value3
data2 value4
data2 value5
data3 value6
data3 value7
data3 value8
data3 value9

So now I would like to copy all the values in column2 of ws2
corresponding to each unique data row and paste in ws1 and I would like
to take transpose while pasting these in ws1. So, the finished data
looks like
this below....

Final data in ws1 looks like..
column1 column2 column3 column 4 column 5
data1 value1 value2 value3
data2 value4 value5
data3 value6 value7 value8 value9

I can do this manually by sorting ws2 by first column and copying the
rows for same data in column1 and then do paste special and transpose
data....but I have to do this for a list that is thousands of rows
long.
So the logic flow will look something like this.....
1. find and select rows with same value in column1 of ws2
2. Copy data in column2 of those selected rows
3. Find the row with the same data in column1 of ws1 as in column1 of
selection in ws2
4. Paste the copied cells (and take transpose at the same time) in ws1
starting at some specified column.

Any help is very appriciated.

Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=527623