Merging Updated Info Row With Old Row

a little task that I'm trying to accomplish. twice a day, a coworker of mine puts out a report on all the jobs we have going for the next couple of days. I paste her report into my own, hide the columns I don't care about, and format the way I like, and add in column U, which holds my comments about the job. It ends up looking something like this:

escelex1.PNG

Later that afternoon, I get the updated copy of her report, in which the B number and customer name always stay the same, but some of the info might change, for example the HOLD column, or the boards or sten columns might change.

What I would like to do is to paste in the afternoon copy of the report, and to have excel merge duplicate rows in such a way that I have the afternoon information from her report (columns B-Q) and keep the comments that I had put in the morning record's row.

When I paste her afternoon report into my spreadsheet, I get duplicate entries looking like this: escelex2.PNG

But I want to be able to merge the data, so that it looks like this: escelex3.PNG

Does that make sense? I want the afternoon version of the data, with no duplicates, but I don't want to delete the comments that I put in in the morning (which is what the "remove duplicates" button is doing)