2

I'm familiar with the UNIQUE 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

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

1
  • There's not built-in solution AFAIK. Maybe try a Pivot table (but maybe not the best fit) ? or a simple script ? either solution will always be much worse than a simple transpose -> unique -> transpose
    – pjmg
    Sep 3, 2019 at 7:00

2 Answers 2

0

Google Sheets doesn't have a "built-in feature" that return unique column values. Your workaround (using TRANSPOSE) is the way to do it.

Reference

Google Sheets function list

0

With data in the first row:

=transpose(unique(transpose(A1:J1)))

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.