Hi,

Could you please help me on the below.
I need transform the top table to the bottom table using Loop.

Name Age English Maths Science
Adam 24 1 2 3
John 32 4 5 6
Lisa 12 9 8 7



Name Age Subject Score
Adam 24 English 1
Adam 24 Maths 2
Adam 24 Science 3
John 32 English 4
John 32 Maths 5
John 32 Science 6
Lisa 12 English 9
Lisa 12 Maths 8
Lisa 12 Science 7


Any feedback is much appreciated.

Thanks.