I have data into this format
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str40 companylevel str121 itemname float(year1 year2 year3 year4 year5)
"340007 - Ahmed Hassan Textile Mills Ltd." "         P1. Net Profit  margin / Net profit to sales (F10 as % of F1)"                                                    -.52 -.09   .2  .56 1.65
"340007 - Ahmed Hassan Textile Mills Ltd." "         P2. Asset turnover (F1 to Avg {Current year(A+B),previous year (A+B)})"                                            .94 1.04 1.23  1.6 1.57
"340007 - Ahmed Hassan Textile Mills Ltd." "         P3. Return on Assets  (F10 as a % of Avg {Current year(A+B),previous year (A+B)}"                                 -.49 -.09  .24   .9 2.59
"340007 - Ahmed Hassan Textile Mills Ltd." "         P4. Financial leverage (Avg. {Current year(A+B),previous year (A+B) to Avg. Current year(C),previous year (C))})" 1.95 2.03  2.2 2.35 2.41
"340007 - Ahmed Hassan Textile Mills Ltd." "         P5. Return on equity (F10 as % of Avg {Current year(C),previous year (C)}"                                        -.96 -.18  .53 2.12 6.25
end
i want to convert this data into

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str40 compnayname int year float(p1netprofitmarginnetprofittosale p2assetturnoverf1toavgcurrentyea p3returnonassetsf10asaofavgcurre)
"340007 - Ahmed Hassan Textile Mills Ltd." 2016 -.52  .94 -.49
"340007 - Ahmed Hassan Textile Mills Ltd." 2017 -.09 1.04 -.09
"340007 - Ahmed Hassan Textile Mills Ltd." 2018   .2 1.23  .24
"340007 - Ahmed Hassan Textile Mills Ltd." 2019  .56  1.6   .9
"340007 - Ahmed Hassan Textile Mills Ltd." 2020 1.65 1.57 2.59
end
Kindy help me in this regard