input float id int year str24 province str33 city float(land3 area3)
26731 2007 "黑龙江省" "七台河市" 10 .103
26994 2007 "黑龙江省" "七台河市" 5 .159
26765 2007 "黑龙江省" "七台河市" 706 6.7619
26793 2007 "黑龙江省" "七台河市" 701 28.9467
27175 2007 "海南省" "三亚市" 706 9.526
27348 2007 "海南省" "三亚市" 5 141.4569
27341 2007 "海南省" "三亚市" 8 18.2736
29428 2007 "福建省" "三明市" 705 6.3525
32078 2007 "福建省" "三明市" 706 23.07255
27776 2007 "福建省" "三明市" 8 93.2513
end
我想把这个长数据变成宽数据,但得到的结果如图。
请问这要怎么解决呢?谢谢解答!