0

I have a Google Sheet with 100 rows and 2 columns.

The first column is a 2 letter code - AA, AB, AC and so on. Each code has a corresponding series of comma separated values in the second column.

I want to remove duplicates from the comma separated values in the second column

enter image description here

I'm happy to do this within Google Sheets or download the values and use SublimeText or similar.

My question is similar to this one, but the proposed solution isn't compatible with Google Sheets.

Max Makhrov
  • 17,309
  • 5
  • 55
  • 81
Wiewiorowski
  • 5
  • 4

1 Answers1

0
=ARRAYFORMULA(JOIN(",",TRANSPOSE(UNIQUE(TRANSPOSE(TRIM(SPLIT(B2,",")))))))

Drag fill down

TheMaster
  • 45,448
  • 6
  • 62
  • 85
  • Thanks - if I paste this over the first value in column B, I get a circular dependency error. If I paste it in the empty cell above the first value, it works, but when I drag down it updates all cells with the lowermost value it affects (if that makes sense). – Wiewiorowski Sep 20 '17 at 13:55
  • Paste it in C column. In C1 copy and paste..And drag fill down. – TheMaster Sep 20 '17 at 14:08