Monday, November 13, 2017

yogi_Combine Row Unique Words In Each Row Stating With Column B For Indefinite Number Of Columns

Google Spreadsheet   Post  #2285

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-13-2017
question by: S T 2
https://productforums.google.com/forum/#!topic/docs/vow6-BrFhqE;context-place=forum/docs
Show unique words
Is there a formula or other method that will output all of the unique words from a cell or range of cells into a new cell?

For example:

Input cells:
I like dogs
I like cats
Cats and dogs are good pets

Output cell:
I like dogs cats and are good pets