Rows to column in backend script

[#1]

The value in the table are in format as shown in screenshow named 'current' (attached). I want to create a qvd out of it that has format as shown in screenshot named 'desired'  (attached). Any suggestions? Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#3]

Thanks Gysbert. It works perfect!

[Anonymous]

using generic load you can do this.