Techniques to Filter Out Repetitive Company Names in Excel

Hi everyone, I have a list of company names in a column However, quite a number are repetitive and I want to filter it out I tried using Formula but it didn't work. I also prompted with gpt but the output was not correct Can anyone help out with the right prompt or techniques to use