I need help to pivot a seq. file with 2 columns to another seq. file with 2 columns.
Code: Select all
Input Sequential File
------------------
Name Score
------------------
Ramyt 1,2,3
Renai 5,6,7,8,9,10,345,122,456
Scott 345,67,23,1,8,4,45,89,23,78,90,100,60,23,12
Brian 23,45
etc
The length of the score is varying comman seperated list
I want the output as follows
------------------
Name Score
------------------
Ramyt 1
Ramyt 2
Ramyt 3
Renai 5
Renai 6
Renai 7
and so on
Any idea ?