Rows to Columns dynamically without Cross Table

[Anonymous]

Dear Experts,

I would like to develop a script which converts the rows into columns dynamically

Since the data is huge the Cross Table is not the optimized way and the Customer don't want the same thing in the layout by Pivot.

Attaching a sample data and the kind of output needed for your kind reference.

Kindly help

Thanks & Regards

Jeba

[petter · Accepted solution]

This should give you an idea of how to do pivot in script dynamically: