我有一个包含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_2
sheet_2
。本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句