Hot answers tagged

1

For a formula-only solution, like bosco_yip's, UNIQUE() would be needed... So: =TEXTJOIN(",",TRUE, UNIQUE( FILTERXML("<Group><Elements>"& SUBSTITUTE(A1, ", ", "</Elements><Elements>")& &...


1

My favorite terminal csv editor is visidata: https://www.visidata.org/


Only top voted, non community-wiki answers of a minimum length are eligible