Help how onto transpose single column table using the edit script ?

[prahlad_infy]

Hello Sirs ,

Help how onto transpose using the script ? 

I am have only one column in a table , there are no other column . 

Thanking You Sirs .

[martinpohl · Accepted solution]

Here you go, but there are no datas in table:

Data:
LOAD * INLINE [
Column
Field1
Field2
Field3
Field4
];

FinalData:
LOAD * INLINE [
F1
];

let vRows = NoOfRows('Data')-1;
for vLoop = 0 to $(vRows);
let vField = peek('Column',$(vLoop),'Data');

left join (FinalData) load
'$(vField)' as "$(vField)"
AutoGenerate 1;
next

drop field F1 from FinalData;

[prahlad_infy]

Thanking you sir

[Frank_Hartmann]

you can use a pivot table and drag the Column Field to the upper right until the blue horizontal line appears.
Not neccessary to change the script in this case but if so, you can use the transpose function in File Wizard (Enable Transformation Step --> Rotate-->Transpose). This will generate you a separat Column for each Field!