The RATS Software Forum

Hello,

Using various do/dofor combinations, I've been trying to convert an excel table of the form:
_______ January _February ...
1960 _____ x1_____ x2
1961 _____ x13____ x14
...

into a series. No success yet. Is there a simple way to do this ?

Thanks a lot,
Raph

You would probably need to either:

a) Save the data into a text (removing the horizontal and vertical labels) and read it in using DATA(FORMAT=FREE,ORG=ROWS), or

b) Write an Excel macro to transform the table into a single column or row.