Lets say I have 100 columns with various character strings. I want to search all of the columns to see if they contain the word "Apple". I then want to create another column that creates a list of all the columns that contained the word "Apple". Example: Col1 Col2 Col3 Results Apple Berry Pear Col1 Berry Apple Apple Col1, Col 2 Pear Pear Pear None Any help with this would be appreciated.
... View more
