Table into series

For questions that don't fall into one of the categories above, such as working with the RATS interface, using Wizards, etc.
raphael
Posts: 15
Joined: Sat Mar 14, 2009 11:27 am

Table into series

Unread post by raphael »

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
moderator
Site Admin
Posts: 269
Joined: Thu Oct 19, 2006 4:33 pm

Re: Table into series

Unread post by moderator »

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.
Post Reply