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
Table into series
Re: Table into series
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.
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.