Filling some empty column of one file from another data file without using join or append?

praty2094

I have two data sheet which needs to be combined into a single file. The master data sheet contains all information but the employee details are missing, these need to be filled up from another data sheet. How can I do it without using join or append function as these gives added columns or rows.?

Any help would be appreciated!!

Thanks!!

Final-output.PNG

Input-file.PNG

Master-file.PNG

Join

Accepted answers

BenMoss

Hi,

The join tool is exactly what you are after here, and though you mention that it gives 'added columns', you can use a select tool after the join (or even within the join) in order to remove any unecessary columns.