I would like to have a query wherein I would like to transpose the contents of one table onto another table. Let's say my first table has 5 rows and 3 columns and I have created a table with 3 rows and 5 columns .
Can anybody suggest an efficient way. I have tried to do it using multiple insert statements but want to know a better way .
Any suggestions would be helpfull

Thanks
Saurav

This is a recurrent problem. Just search for "Transpose" in this forum, and you will certainly find earlier threads with solutions and links to solutions.

Good luck.