Hi, I have two excel sheets. I need to merge, combine or sync them. Some of the column headers have the same name.
For example,
Sheet one has column headers: job number, job name, job ID
Sheet two has column headers: job number, job category.
Attached are sample sheets with made-up information but it shows what I need to do.
I need these two sheets to become one sheet. Sheet 1 and sheet 2 job numbers need to match us and place the job category in the correct row to match the job number.
Any idea how to do this?
Thank you for your time
Kimberly
Bookmarks