我有一个包含3列的Excel文件。第一列包含国家/地区代码，第二列包含国家/地区名称，第三列包含年份。
总共我有354个不同的国家/地区值和37个不同的年份（从1980年到2016年）。
这是我文件的简化示例。在此示例中，有3个不同的国家/地区值和6年（从1980年到1985年）。
| COL A | COL B | COL C |
+-----------+-----------+----------+
AT | Austria | 1980
AT | Austria | 1981
AT | Austria | 1982
AT | Austria | 1983
AT | Austria | 1984
AT | Austria | 1985
AT | Austria | 1980
BE | Belgium | 1980
BE | Belgium | 1981
BE | Belgium | 1982
BE | Belgium | 1983
BE | Belgium | 1984
BE | Belgium | 1985
CH07 | Ticino | 1980
CH07 | Ticino | 1981
CH07 | Ticino | 1982
CH07 | Ticino | 1983
CH07 | Ticino | 1984
CH07 | Ticino | 1985
我想要的是这样的：
| COL A | COL B | COL C | COL D |
+-----------+-----------+----------+-----------+
AT | Austria | 1980 | A
AT | Austria | 1981 | A
AT | Austria | 1982 | A
AT | Austria | 1983 | A
AT | Austria | 1984 | A
AT | Austria | 1985 | A
AT | Austria | 1980 | B
AT | Austria | 1981 | B
AT | Austria | 1982 | B
AT | Austria | 1983 | B
AT | Austria | 1984 | B
AT | Austria | 1985 | B
AT | Austria | 1980 | C
AT | Austria | 1981 | C
AT | Austria | 1982 | C
AT | Austria | 1983 | C
AT | Austria | 1984 | C
AT | Austria | 1985 | C
AT | Austria | 1980 | D
AT | Austria | 1981 | D
AT | Austria | 1982 | D
AT | Austria | 1983 | D
AT | Austria | 1984 | D
AT | Austria | 1985 | D
BE | Belgium | 1980 | A
BE | Belgium | 1981 | A
BE | Belgium | 1982 | A
BE | Belgium | 1983 | A
BE | Belgium | 1984 | A
BE | Belgium | 1985 | A
BE | Belgium | 1980 | B
BE | Belgium | 1981 | B
BE | Belgium | 1982 | B
BE | Belgium | 1983 | B
BE | Belgium | 1984 | B
BE | Belgium | 1985 | B
BE | Belgium | 1980 | C
BE | Belgium | 1981 | C
BE | Belgium | 1982 | C
BE | Belgium | 1983 | C
BE | Belgium | 1984 | C
BE | Belgium | 1985 | C
BE | Belgium | 1980 | D
BE | Belgium | 1981 | D
BE | Belgium | 1982 | D
BE | Belgium | 1983 | D
BE | Belgium | 1984 | D
BE | Belgium | 1985 | D
CH07 | Ticino | 1980 | A
CH07 | Ticino | 1981 | A
CH07 | Ticino | 1982 | A
CH07 | Ticino | 1983 | A
CH07 | Ticino | 1984 | A
CH07 | Ticino | 1985 | A
CH07 | Ticino | 1980 | B
CH07 | Ticino | 1981 | B
CH07 | Ticino | 1982 | B
CH07 | Ticino | 1983 | B
CH07 | Ticino | 1984 | B
CH07 | Ticino | 1985 | B
CH07 | Ticino | 1980 | C
CH07 | Ticino | 1981 | C
CH07 | Ticino | 1982 | C
CH07 | Ticino | 1983 | C
CH07 | Ticino | 1984 | C
CH07 | Ticino | 1985 | C
CH07 | Ticino | 1980 | D
CH07 | Ticino | 1981 | D
CH07 | Ticino | 1982 | D
CH07 | Ticino | 1983 | D
CH07 | Ticino | 1984 | D
CH07 | Ticino | 1985 | D
所以我想要的是：
我怎样才能做到这一点？手动执行此操作比较繁琐，您可能会犯错误。
不幸的是，很难用语言来解释，但是我希望这个例子能有所帮助。
谢谢
尝试这个：
sheet_2）sheet_2sheet_2。本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句