Removing duplicates in google sheets

0
votes

I have a sheet with words in one column

  • w1
  • w2
  • w3, w2
  • w1, w2
  • w1
  • w1

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.

2
joingoogle-sheetsduplicatesunique
please share more code – user8626261
We can't access your spreadsheet. Please fix permissions. – JPV
Ok, try this one docs.google.com/spreadsheets/d/… – Karel

2 Answers

2
votes

Try this:

=UNIQUE(transpose(ARRAYFORMULA(TRIM((split(SUBSTITUTE(Join(",",A1:A6),",, ",","),",")) ))))
1
votes
  =UNIQUE(transpose(A10:H10))

UNIQUE only works with rows.