How to merge two excel files based on common column ?

7 次查看(过去 30 天)
I have two excel sheets that I need to combine into one.
For example
File1:
ID Name
1 abc
2 xyz
3 mno
File2:
ID Job
1 teacher
2 singer
3 driver
Once I import these two excel files, I want to combine them into one, based on the common column "ID"
Output file:
ID Name Job
1 abc teacher
2 xyz singer
3 mno driver

采纳的回答

Ameer Hamza
Ameer Hamza 2020-11-17
See innerjoin(): https://www.mathworks.com/help/matlab/ref/innerjoin.html or outerjoin(): https://www.mathworks.com/help/matlab/ref/outerjoin.html. Use whichever is suited for your purpose.

更多回答(0 个)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by