作者:流浪1种无奈 | 来源:互联网 | 2023-06-21 06:27
Ihavetwoexcelsheets.Ihavetomergethetwosuchthatthevaluesinonematchwiththeother.F
I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg.
我有两张excel床单。我必须将两者合并,使得一个中的值与另一个匹配。例如。
The first excel, the 2nd excel
1 t 1 tes1
2 5 3 tes3
3 t 4 tes4
4 g
Notice that in the first column of the 2nd excel, 2 is missing, so I want the first excel to look like this,
请注意,在第二个excel的第一列中,缺少2,所以我希望第一个excel看起来像这样,
1 tes1 t
2 5
3 tes3 t
4 tes4 g
I am new to excel. Any help on this will be highly appreciated.
我是excel的新手。任何有关这方面的帮助将受到高度赞赏。
1 个解决方案