How to convert column into row in qlikview sql ?

[#1]

HI,

I am new to qlikview.

i would like to convert column  data into row.

example :

Field Key

100    1

200     2

300     3

400     4

500   5

output :

1        2          3       4       5

100    200    300   400   500

can someone please help me ?

Thanks!.

[#2]

This is all done by Transformation step..There is more option available to modify the table..

after clicking next there is a option of cross table which allow you to transform row to column.