* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 code str132 学历 str4 year double 数量
"000001" "其他" "2018" 34626
"000001" "其他" "2019" 34253
"000001" "其他" "2020" 38097
"000002" "其他" "2013" 35330
"000004" "其他" "2012"   277
"000004" "其他" "2013"   243
"000004" "其他" "2014"   220
"000004" "其他" "2015"   208
"000004" "其他" "2016"   179
"000004" "其他" "2017"   172
"000004" "其他" "2018"   210
"000004" "其他" "2019"   251
"000004" "其他" "2020"   264
"000004" "合计" "2015"   208
"000004" "合计" "2016"   179
"000004" "合计" "2017"   172
"000004" "合计" "2018"   210
"000004" "合计" "2019"   251
"000004" "合计" "2020"   264
"000005" "其他" "2012"   382
"000005" "其他" "2013"   376
"000005" "其他" "2014"   421
"000005" "其他" "2015"   535
"000005" "其他" "2016"   618
"000005" "其他" "2017"   705
"000005" "其他" "2018"   745
"000005" "其他" "2019"   680
"000005" "其他" "2020"   629
"000005" "合计" "2015"   535
"000005" "合计" "2016"   618
"000005" "合计" "2017"   705
"000005" "合计" "2018"   745
"000005" "合计" "2019"   680
"000005" "合计" "2020"   629
"000006" "其他" "2012"   290
"000006" "其他" "2013"   296
"000006" "其他" "2014"   329
"000006" "其他" "2015"   352
"000006" "其他" "2016"   370
"000006" "其他" "2017"   370
"000006" "其他" "2018"   377
"000006" "其他" "2019"   385
"000006" "其他" "2020"   397
"000006" "合计" "2013"   296
"000006" "合计" "2014"   329
"000006" "合计" "2015"   352
"000006" "合计" "2016"   370
"000006" "合计" "2017"   370
"000006" "合计" "2018"   377
"000006" "合计" "2019"   385
"000006" "合计" "2020"   397
"000007" "其他" "2012"   762
"000007" "其他" "2013"   674
"000007" "其他" "2014"   614
"000007" "其他" "2015"   121
"000007" "其他" "2016"   155
"000007" "其他" "2017"   102
"000007" "其他" "2018"    84
"000007" "其他" "2019"    84
"000007" "其他" "2020"    76
"000007" "合计" "2015"   121
"000007" "合计" "2016"   155
"000007" "合计" "2017"   102
"000007" "合计" "2018"    84
"000007" "合计" "2019"    84
"000007" "合计" "2020"    76
"000008" "其他" "2012"  1685
"000008" "其他" "2013"  1622
"000008" "其他" "2014"  1278
"000008" "其他" "2015"  2617
"000008" "其他" "2016"  1903
"000008" "其他" "2017"  2417
"000008" "其他" "2018"  2631
"000008" "其他" "2019"  2618
"000008" "其他" "2020"  2394
"000008" "合计" "2013"  1622
"000008" "合计" "2014"  1278
"000008" "合计" "2015"  2617
"000008" "合计" "2016"  1903
"000008" "合计" "2017"  2417
"000008" "合计" "2018"  2631
"000008" "合计" "2019"  2618
"000008" "合计" "2020"  2394
"000009" "其他" "2012"  8524
"000009" "其他" "2013" 11953
"000009" "其他" "2014" 11915
"000009" "其他" "2015"  8202
"000009" "其他" "2016"  8887
"000009" "其他" "2017" 10944
"000009" "其他" "2018" 13620
"000009" "其他" "2019" 13179
"000009" "其他" "2020" 13345
"000009" "合计" "2015"  8202
"000009" "合计" "2016"  8887
"000009" "合计" "2017" 10944
"000009" "合计" "2018" 13620
"000009" "合计" "2019" 13239
"000009" "合计" "2020" 13345
"000010" "其他" "2012"   420
"000010" "其他" "2013"   596
end

我想调整成
代码       年份   其他   合计
000001   2012   12      10
000001   2013   18      90
000002
这种 ，怎么调整啊
reshape 了 但是不行 没法同时设置代码和年份两个条件