I am trying to get a data in a specified format, currently this is in the form.

enter image description here

I want to write a sql query which would get me the data in this form
enter image description here

I tried with converting it to array and unnest but not getting the desired result, any help would be much appreciated. Thanks!

I tried with converting it to array and unnest but not getting the desired result, any help would be much appreciated. Thanks!