Import Problem

[88fr.leo]

Hello, my name is Leo, maybe you are able to help me.

In one file I have two worksheet, on with a monthly frequency and another with a custom frequency (from 1 to 12 - what means that it is annual).
I have a serie in the monthly one and i want to "break" it into another series the other frequency worksheet, but I want that every january be into number 1, february 2 till december 12. And if this is possible, the program should name the new series with the current year that it is representing.
It is like taking one stack and make another stacks with the same number of information.


Thx :D

[EViews Gareth]

I don't follow. The second sheet is annual, and covers twelve years? Does the first sheet also cover those 12 years?

[88fr.leo]

I made a file trying to explain my problem. The File I have is monthly and I want to import this file in a "custom" way. In the excel I am sending have the information necessary.

[EViews Gareth]

Still not sure I fully understand, but try:

Code: Select all

wfopen test.xlsx range="Monthly!a1:b228" pageunstack @year @month @ currency