Transpose the table

[rafik2k]

Hi,
I am in process of creating one job where I need to transponse a table i.e. row into column and column into row.

For example, input is like this

Table col1 col2 col3
row1 10 20 30
row2 15 35 45
row3 25 55 65


output would be like this:
Table col1 col2 col3
row1 10 15 25
row2 20 35 55
row3 30 45 65

Thanks in advance for any tips or links to pasts posts that might help.

[rafik2k]

Initially I thought that pivot stage would help, but having checked privot stage I found that it's for different requirement.

[ray.wurlod]

Search the forum for "vertical pivot". It may be easier, if your database has one, to use a table transpose function.