Achieve Pivot table kind in script

[#1]

Hi,

below is the input data:

and below is the required output:

I managed to achieve this via Cross Table and later Pivot table in frontend. But as per requirement I am supposed to get this in Scripts. How can I reach to the required out put in scripts?

Please help.

Regards,

Dawar

[#2]

[#3]

this is the result