CODEWITHSUNDEEP
joingoogle-sheetsduplicatesunique
Karel
Karel

Reputation: 85

Removing duplicates in google sheets

I have a sheet with words in one column

I would like to have a column of words without doubles =JOIN(",",A1:A6)(all in a row) =SUBSTITUTE(A8,", ",",") (remove spaces) =SPLIT(A9,",") (split to columns) =UNIQUE(A10:H10) (remove duplicates). The UNIQUE command does not work, I still have the duplicates there (see https://docs.google.com/a/btlnet.com/spreadsheets/d/1ZTq6Xg1bm8w_dFBtnGKDR3Kvq86gmUw3W7SkpPYqw4g/edit?usp=sharing). Please help.

Upvotes: 0

Views: 680

Answers (2)

TheMaster
TheMaster

Reputation: 50697

  =UNIQUE(transpose(A10:H10))

UNIQUE only works with rows.

Upvotes: 1

Ed Nelson
Ed Nelson

Reputation: 10259

Try this:

=UNIQUE(transpose(ARRAYFORMULA(TRIM((split(SUBSTITUTE(Join(",",A1:A6),",, ",","),",")) ))))

Upvotes: 2

Related Questions