Import Data From Landscape Format
 

I have a data set from an old Pascal program that was exported into
this fomat:

ID # : 10106
Sex : Female
Raw Scores : 1 4 1 0 3 6 3
T Scores : 53 114 65 43 64 83 42


I need the headers to be ID#, Sex, Raw Scores 1-7 and T Scores 1-7 and
then to pick up the data and place it in the appropriate cell.


Is there a script that will accomplish this?
Thank you for your help!!