I have the following table contents:
MONTH STATES
----------- ----------------------
1 5177
2 640
3 6029
4 11086
5 2131


I need to convert this to:

MONTH 1 2 3 4 5

STATES 5177 640 6029 11086 2131


How can I do this?

TIA.

There are a number of threads in this forum about this .. One such thread is :

Getting data from several rows onto one

Unless you have a definitve list of columns (which in this case is MONTH), you do not have a pure SQL

HTH

Sathyaram