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