title: Reshaping Panel data from wide to long form on Stata
body: <p>I have the following data which i want to convert in to long form.</p>
  <pre><code>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
  </code></pre>
  <p>i have tried</p>
  <pre><code>rename (Albania*) _=
  
  reshape long _ , i(year) j(cname) string
  </code></pre>
  <p>My target is to reshape the data in to</p>
  <pre><code>year Country 1st Pillar 2nd Pillar
  2007 Albania 2.6627262 ..........
  2008 Afghanistan 3.4627262 ......
  2009 Rwanda 2.87527262 ........
  </code></pre>
  <p>Please help</p>