I have the following data which i want to convert in to long form.
year pillars Albania Algeria Angola Argentina Armenia
2007 11th pillar: Business sophistication 3.6597311 3.0576515 3.4918021 3.5915523
2007 1st pillar: Institutions 2.5269075 4.2349405 4.8290871 2.4191433
2007 8th pillar: Financial market development 3.1519065 3.3876948 4.2213437 3.3508933
2007 10th pillar: Market size 4.1176545 3.6155731 3.4919841 4.5409658
2007 3rd pillar: Macroeconomic environment 2.0992993 2.9498665 2.9116902 2.8697405
2007 6th pillar: Goods market efficiency 4.6865753 6.4130034 4.9136432 4.9837896
2007 7th pillar: Labor market efficiency 5.4585795 5.4442673 5.6051684 4.959185
2007 2nd pillar: Infrastructure 3.3452073 3.263606 3.9682149 3.2552587
2007 12th pillar: Innovation 2.9956383 2.5408542 2.9645087 2.55345
2007 4th pillar: Health and primary education 3.1417448 3.8764841 2.9889512 3.4001686
2007 9th pillar: Technological readiness 3.5059683 3.8649718 3.5275836 3.7134801
2007 5th pillar: Higher education and training 2.0516761 2.9958828 3.0272646 2.8476234
2008 6th pillar: Goods market efficiency 4.5599721 6.0840204 5.0546257 4.7323749
2008 8th pillar: Financial market development 3.3970137 3.2761169 4.1375279 3.4260495
2008 4th pillar: Health and primary education 3.3231335 3.4470269 2.9351999 3.4970362
2008 2nd pillar: Infrastructure 3.2702241 3.0345199 3.991308 3.2979792
2008 11th pillar: Business sophistication 3.6998688 2.9421291 3.4639852 3.6817465
2008 1st pillar: Institutions 2.6627262 4.1702126 4.7674605 2.4751191
2008 12th pillar: Innovation 2.8907774 2.5225983 3.1894787 2.5565684
2008 3rd pillar: Macroeconomic environment 2.2182377 2.6554869 2.8689172 2.7673965
2008 9th pillar: Technological readiness 3.6122833 3.5180317 3.5546848 3.7479288
2008 10th pillar: Market size 4.3590407 3.3022641 3.4714751 4.5656952
2008 5th pillar: Higher education and training 2.2175048 2.9590652 2.9159996 2.8734283
2008 7th pillar: Labor market efficiency 5.4704289 5.3445615 5.5795324 5.0555898
2009 2nd pillar: Infrastructure 3.3707739 3.1260049 3.9369082 3.3472921
2009 4th pillar: Health and primary education 3.6190447 3.200171 2.9427627 3.4927499
2009 8th pillar: Financial market development 3.5542132 3.2977487 4.2010233 3.4639264
2009 7th pillar: Labor market efficiency 5.4790325 5.2768175 5.5368148 5.0000323
2009 3rd pillar: Macroeconomic environment 2.4299682 2.6385734 2.9480703 2.7106974
i have tried
rename (Albania*) _=
reshape long _ , i(year) j(cname) string
My target is to reshape the data in to
year Country 1st Pillar 2nd Pillar
2007 Albania 2.6627262 ..........
2008 Afghanistan 3.4627262 ......
2009 Rwanda 2.87527262 ........
Please help