Import Data From Landscape Format

[dsjrcw]

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!!

 

[Jean-Yves]

Hi,

Copy, paste special , transpose
Regards
JY

 

[dsjrcw]

Hi,

Copy, paste special , transpose
Regards
JY

Thank you for the reply!! I have over 800 subjects in this format.
Transpose would be really time consuming. Is there a script that would
work?

Thanks!

 

[dsjrcw]

Hi,

Copy, paste special , transpose
Regards
JY

Thank you for the reply!! I have over 800 subjects in this format.
Transpose would be really time consuming. Is there a script that would
work?

Thanks!

 

[Jean-Yves]

Hi again,

the purpose of this newsgroup is to help you building code.
So far, what do you have.
If nothing, try to record when you do a transpose operation.
Try to understand the code (mail back if needed)
Then try to apply this to all other ranges.(mail back if needed)
Regards
Jean-Yves