| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping landscape setup from import | Excel Discussion (Misc queries) | |||
| import data format | Excel Worksheet Functions | |||
| Import Data From Landscape Format | New Users to Excel | |||
| Import data format, need help | Excel Discussion (Misc queries) | |||
| Import data from Web cvs format | Excel Programming | |||
Linear Mode
