how to convert all the columns to rows and rows to columns dynamically

See more:

SQL-Server-2008R2

Hi,

I have a table with few columns and rows.

Master Contract Number con Net Revenues Deployed Payroll Net (Loan)/Borrow Payroll Total Payroll Total Subcontractor Costs
9940012364 0 0 0 0 0
9940040036 2827.58127 81.4233 1551.70266 1633.12596 92.07216
9940052615 1624.96347 120.98094 218.0292 339.01014 244.44309
9940071895 0 0.78807 -0.68328 0.10479 0
9940117981 640.27911 0 213.83937 213.83937 7.85265
9940146065 0 0 0 0 0


so here now the rows has to become columns and columns has to become rows dynamically..
Something like Transpose.
Please help me.

Thanks in advance.