Re-arranging the data

Hi,

I have the data in the format mentioned below in the excel,

Column1 Column2
Row1 Name John
Row2 Name James
Row3 Dept physics
Row4 Dept Chem

i want the data in the format as,
Column1 Column2
Row1 Name JohnJames
Row2 Dept physicsChem

Please let me know the solution using Pivot Table.

Thanks for the help.