Sunday, August 12, 2012

yogi_Extract List of Unique Items From A Column Of Comma Delimited Strings

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #687   Aug 12, 2012

user a_p3rson said: (!category-topic/docs/spreadsheets/cbRvbvjPNNc%5B1-25%5D)
List of unique comma-space separated responses
I have a column of text responses, which are all short responses. However, each cell (may) contains more than one response, separated by a comma-space. How do I get a list of the unique responses? An example would be:
H1: Circle, Square, Triangle
H2: Octagon, Triangle
H3: Octagon
H4: Diamond, Circle
would return:
(in no particular order, however.)

following is a solution to a bit more generalized problem in the sense that I have extracted list of unique items from strings of comm-space sepatreated, or comma separated items in a column