Converting

[EViews Gareth]

Once you have it in as a panel, as Startz described, then click on Proc->Reshape Current Page->Unstack in new page, and enter "year" as the unstacking ID, and "country" as the observation id.

[drewesparon]

Should i do this in excel first then import it to eviews. or is there an easier way to do it in eviews?

[drewesparon]

ok will try that now thank you

[drewesparon]

i tried it but i keep getting an error message

[EViews Gareth]

Ah, yes. Delete the series with long names (or rename them if you need them).

[drewesparon]

Thank you

[drewesparon]

It worked thank you both so much :) now eviews is telling me that the workfile is too large and i wont be able to save any work that i do. Is there a way to pass this

[EViews Gareth]

Purchase the full version :D

[drewesparon]

I have a student version at the moment so i guess i will have to purchase the full version. Thanks