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

Import Data From Landscape Format
 

Hi,

Copy, paste special , transpose
Regards
JY
wrote in message
oups.com...
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!!

Import Data From Landscape Format
 

Jean-Yves wrote:
Hi,

Copy, paste special , transpose
Regards
JY
wrote in message
oups.com...
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!!

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!

Import Data From Landscape Format
 

Jean-Yves wrote:
Hi,

Copy, paste special , transpose
Regards
JY
wrote in message
oups.com...
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!!

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!

Import Data From Landscape Format
 

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

wrote in message
oups.com...

Jean-Yves wrote:
Hi,

Copy, paste special , transpose
Regards
JY
wrote in message
oups.com...
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!!

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!