stack data from excel

[mikela]

hi,
i have a lot of data in excel format, in each sheet one variable across 230 individuals, for 82 variables (so 82 sheets).

I need to reshape these data into one big panel, stacking the data. Currently i'm trying to use pagestack but i don't manage to make it work.
So here is what i am doing:

first i import the data, putting a variable in each page:

pageload(page=x_11350) "data.xlsx" range="x_11350"
pageload(page=x_11110) "data.xlsx" range="x_11110"

and the workfile looks like the attached. Now i would have to import 82 pages and then stack them across the ids (b1, b2, etc). and with each series having the X_11350 etch name, Ideally in one new page.... not sure i'm being clear.

If you have any other ideas as to to how solve this problem, i would be very greatful.

Many thanks
Michela

[EViews Gareth]

http://forums.eviews.com/viewtopic.php? ... 5747#p5747