Perform the following steps:
- Make sure you have a column header, such as "Names";
- Go to Data --> Sort & Filter, click 'Advanced';
- In the field 'List range:' enter A:A;
- Click 'Copy to another location';
- In the field 'Copy to:' enter B1;
- Click 'Unique records only';
- Click 'OK'.