converting rows into columns

hi,

i wanted to convert my all the data of one table into column name.

ex.: name     dept

      -------    -------

      X           A

      Y          B

      Z          C

Desired Out put is ---

name   dept   A    B    C    X    Y    Z

------    -----  --     --   --    --    --    --

X          A

Y         B

Z          C

Required out put in SQL query.

Thanks,

Rakesh Mishra