How to transpose columns into rows or rows into columns in sql server 2008

Question

I have a query which gives the output like Test1           Test21000             500 I have to transpose like Test1         1000Test2           500

Mudassar · Accepted Answer

ReferFive methods converting rows to columns  Microsoft SQL Server Convert Rows to Columns Columns to Rows in SQL Server using PIVOT and UNPIVOT

Convert Rows to Columns, Columns to Rows in SQL Server using PIVOT and UNPIVOT