How does the unique function work in Google Sheets?

Just like before, UNIQUE returns unique values from the range. The results are displayed from cell C2 onwards. You can see that the output values flow downwards in the spreadsheet and also extend one column to the right. That’s because Google Sheets returns the same number of columns as those in the input range.
For More Information Please Refer:

You May Also Like to Read: