Copy Unique Values in Google Sheets

GOAL
Copy unique values from one column to another column in Google Sheets (or Excel).


SOLUTION

=UNIQUE(A1:A10)

A1:A10 is the range of cells you hope to narrow to only unique values

Reference

EXAMPLE

Column A:	Column B: Use this formula: =UNIQUE(A1:A13) and get the following:
Dogs Dogs Cats Dogs Dogs Dogs Cats Snakes Cats Turtles Dogs Dogs Cats	Dogs Cats Snakes Turtles