This is fabulous. I'm wondering if there is a way to tweak it to work for me. What I need to do is merge information where any rows which have matching entries in cells columns A thru F will have all other cells in their rows G through infinity merge, but not add/sum any numerical information. In practice, doing this should only replace blank cells with text and/or numbers, but on the off chance that there are two numerical values that need to merge, I would want them both to show. Similarly on the off chance that there were two sets of text, I would want them both to appear in a single cell.

What I'm trying to do is take an updated list of students who have applied to a program which will include students from older lists, but also new students who have applied since the last list was run & merge it with the old list which also contains columns of text and numerical values which have been manually entered. I want to get rid of new blank rows where the entries in columns A-F match 100%, retain the manually entered notes, and not delete or copy information into rows of students who are appearing on the list for the first time (and thus have not had any notes manually entered). So the "copy from line below" formula will not work because in some cases that might copy notes from one student into another since some students will only have a single row whereas others will be repeat. I hope that makes sense. I need to do this weekly, so not having to manually/eyeball deleting duplicate rows & copying/pasting unique note cells would be a godsend.

Any advice would be greatly appreciated!