I'm familiar with the [`UNIQUE`][1] function in Google Sheets and how it works on rows (see Examples 1 & 2 below). Is there a function in Google Sheets that operates similarly on columns? In Example 3 below, `UNIQUE` behaves as expected by treating this as a single unique row. [![Examples 1,2][2]][2] I've worked around this by using `TRANSPOSE(UNIQUE(TRANSPOSE()))` (see Example 4), however would like to know whether there's a built-in solution. [![Examples 3,4][3]][3] [1]: https://support.google.com/docs/answer/3093198?hl=en [2]: https://i.sstatic.net/F9kNK.png [3]: https://i.sstatic.net/1kDsR.png