1. select the range of source data
2. In menu, choose Data > Filter > Standard
3. Check the “no duplication” and “copy results to..” and specify the result destination first column
1. select the range of source data
2. In menu, choose Data > Filter > Standard
3. Check the “no duplication” and “copy results to..” and specify the result destination first column