Hi,

I'm fairly new to Stata, so this question may be somewhat basic

I need to import a decent amount of data from excel into stata. In this case, I have country codes on the y-axis and years on the x-axis, with values in between, organized across several sheets. I'd like to import the data, while reformating it to have country code and year as variables, rather than having each year as a separate variable, which is how it turns out if try to import it now.

Any help is greatly appreciated,
Thanks