Data Transformation

[Alexrp25]

How can I turn a set of rows into a table? What script can I use?

For instance. I want a table like that below:

Month Value
Jan - 1000
Fev - 1100
Mar - 1200
Apr - 1300

to turn into something like this:

Jan Fev Mar Apr
1000 1100 1200 1300

Is there a Sql script or a process I can use?

I hope anyone can help me!

 

[rrrkrishnan]

This is impossible, a column cannot have values which means two different things, ie. for one record the column value cannot be a month and for the other record it cannot be some numeric value.

 

[Zathras]

I think rrrkrishnan mis-read your intent. If you mean for "Jan" "Fev", ... as column names for a new table, then what you are asking for is a pivot table.

There are several good leads in this thread that may provide what you are looking for:

thread183-451930