how to insert data row wise from column wise table?

See more:

SQL-Server

SQL-Server-2008

Hi to all,
I want to insert data from one table to another table. But structure of both table is different. One is column wise and 2nd is row wise. eg is shown below.

table 1::

id parameter id name result Date Patient_Id

1 1 Weight 80 2012-09-30 1

2 2 Systolic Pressure 65 2012-09-30 1

table 2:

id parameter id Weight Systolic_Pressure Date Patient_Id

1 1 80 65 2012-09-30 1

I have table 1 and want to insert data in table format like above format..

Please help me how it is possible...