Hello, I have an excel sheet of user responses. In one column is the name of all the users. I would like in a 2nd column to copy all the names once. I tried using an IF formula but came back with errors.

For example:
Column A
Jake
Jerry
Jerry
Alex
Sally
Sara
Sally

Column B would be as follow
Jake
Jerry
Alex
Sally
Sara