Transpose column to rows and add Single quotation mark for each row

[#1]

How can I use JSL to Transpose one column (:Number) to rows and add single quotation mark for each row? 

or add add single quotation mark for each row of "Number" column, then Transpose to row? 

[#2 · Accepted solution]

Hi @ReliabilityWolf 

Perhaps you can try this JSL script.

//To add prefix single quotation mark
Names Default to Here( 1 );
dt = current data table();
dt:Number << Data Type( Character);
for each row(
	dt:Number = "'" || dt:Number
);

//To transpose Number column to row
// Transpose data table
// → Data Table( "Transpose of dt" )
Data Table( "dt" ) << Transpose(
	columns( :Number ),
	Output Table( "Transpose of dt" )
);