Convert Column into Row in qlikview Backend side ? rotate Tranpose ?

[#1]

HI,

I am new to qlikview.

I really need help and suggestions for this below.

i would like to convert column  data into row.

example :

Field Key

100    1

200     2

300     3

400     4

500   5    <--this data are not fixed. this are the precalculated numbers in another table and i would like to referece those afte rbelow transpose. I have came across other people suggested Inline functionality, but, i believed, that will work if data are static.

so, can please someone suggest any solutions ?

output :

1        2          3       4       5  <--key will become columns 1 to 5 and data from field above will shows as data under each columns.

100    200    300   400   500

can someone please help me ?

Thanks!.

[whiteline]

You don't have to post the questions twice.