Probably several ways...
Make sure your list has a column heading. Select the list including the heading, Data > Filter > Advanced filter, tick copy to another location, insert the location and tick Unique records only.
Best Amazon Echo: What’s the best Alexa speaker?
Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code
Best pro photo editors for Mac 2018
TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?