How to merge two excel files based on common column ?

15 views (last 30 days)
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

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by