I am trying to change the output of my rawdata file. In the rawdata, the output is in the following format

Name Test1 Test2 Test3 Test4

xyz 45 78 88 100

avb -1 89 76 29

But I want to change it to following format

Name Score

xyz 45

xyz 78

xyz 88

xyz 100

xyz 89 (skip -1 cuz it's less than0) 

I am trying to use array and output statement but having trouble. 

Can someone help? 

P.S. I uploaded a pic not sure if it worked.

Best, 

LB