View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dsjrcw@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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!