EViews.com

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.

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

ok will try that now thank you

i tried it but i keep getting an error message

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

Thank you

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

Purchase the full version :D

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