Linking cells/duplicate removal
 

I want to remove duplicate rows. Except some rows have 1 more column than
other rows. therefore still leaving some duplicates. How do i delete
duplicates without shifting cells up to fill the deleted blanks? or How do i
link the last 2 columns so that when a row is deleted in the previous columns
it is also deleted in the column not being checked for duplicates?