trying to take rows and make them into columns

Hello,


I need to write a macro where it takes column a, and moves all to column b on sheet #2, and then takes column D and moves it to column A of sheet#2, and then I need to take specific rows from column C and make them the column headers for columns c through k and v on sheet #2, and then I need to take the corresponding data from column J on the first sheet and move it under each column I created for the datatype in sheet #2.


So basically I have two sheets:

Sheet #1

A , C , D , J
ID# , REQUESTDESCRIPTION , TIMESTAMP , REQUEST'SDATA
id#1 , punchtype1 , 1/21/2006 18:04:00 , 23453675
id#1 , punchtype2 , 1/21/2006 18:04:00 , 34565476


id#2 , punchtype2 , 1/21/2006 18:06:04 , 23456784

and I need to make
Sheet #2

A , B , C through K
TIMESTAMP , ID# , REQUESTDESCRIPTION#1, #2, #3, etc...
1/21/2006 , id#1 , 23453675 , 34565476 , 36575643
1/21/2006 , id#2 , , 23456784


any ideas or help?