For questions that don't fall into one of the categories above, such as working with the RATS interface, using Wizards, etc.
by 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
by 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