If it is a one time job, paste the "new" range underneath the "old" one
Select the obtained range
Select data - Advanced Filter
Filter In Place
Check Unique records only
OK

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post