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.

Table into series

Postby raphael » Mon Dec 07, 2009 4:01 pm

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
raphael
 
Posts: 15
Joined: Sat Mar 14, 2009 11:27 am

Re: Table into series

Postby moderator » Tue Dec 08, 2009 10:23 am

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


Return to Other RATS Usage Questions

Who is online

Users browsing this forum: No registered users and 1 guest