insheet using x.txt, comma clear
rename v1 year
rename v2 one1
rename v3 one2
rename v4 two1
rename v5 two2
drop if year==.
reshape long one two, i(year) j(j)
rename one v1
rename two v2
reshape long v, i(year j) j(i)
order year i j
sort year i
outsheet using r.txt,comma replace
附件列表