How to convert rows into different columns

[kirankumarn]

How to convert rows into different columns

Thanks in advance

[ssnaik84]

Look at how to use Pivot and Unpivot

[nbiswas]

It can be achieved in more than I way..depending on the situation.
Prior to PIVOT & UNPIVOT available since Sql Server 2005, the row column transposition was done by using case statement(among other alternatives).

Have a look

Pivot Table Data in SQL Server 2000 and 2005