So ive been trying to make all this data ready to use as panel data in STATA but it is taking ages. If i have to copy paste everything it is gonna take me a couple more hours atleast. So i hope somebody knows how to do this easier and quicker. So i this is the data: http://imgur.com/xLGJ0Mb http://imgur.com/S7Ff16o
And i need it to look like this
http://imgur.com/5z7pUIZ
I would appreciate it so much if anyone could help me out with this!