result set rows to columns

Use Pivot Function to convert row into column.

Syntax:

SELECT
  [non-pivoted column], -- optional
  [additional non-pivoted columns], -- optional
  [first pivoted column],
  [additional pivoted columns]
FROM (
  SELECT query producing sql data for pivot
  -- select pivot columns as dimensions and
  -- value columns as measures from sql tables
) AS TableAlias
PIVOT
(
  <aggregation function>(column for aggregation or measure column) -- MIN,MAX,SUM,etc
  FOR [<column name containing values for pivot table columns>]
  IN (
    [first pivoted column], ..., [last pivoted column]
  )
) AS PivotTableAlias
ORDER BY clause -- optional

thanks all for your help.....
i got my desired output by using the query like this.............

SELECT distinct(inst_ID) as ID,
[PO_Date] = (SELECT distinct(Val_col) FROM TR1 WHERE COL_NAME = 'Date' and inst_ID=m.INST_ID),
[Po_No]= (SELECT distinct(Val_col) FROM TR1 WHERE COL_NAME = 'Po_no' and inst_ID=m.JITS_INST_ID),
[Vendor_Code] = (SELECT distinct(Val_col) FROM TR1 WHERE COL_NAME = 'Vendor_Code' and inst_ID=m.inst_ID),
[Vendor_Name]=(SELECT distinct(Val_col) FROM TR1 WHERE COL_NAME = 'Vendor_Name' and inst_ID=m.inst_ID),
[Total_Amt]= (SELECT distinct(Val_col) FROM TR1 WHERE COL_NAME = 'Total_Amt' and inst_ID=m.inst_ID)
FROM JITS_TR1_VALUE m
GROUP BY inst_ID

with regards.....

siva