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.

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.

[![enter image description here][2]][2]

[![enter image description here][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