Sunday, July 15, 2012

yogi_Set Up Combinations Of Text Between Two Columns Separated By Specified Combination Character

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #628   Jul 15, 2012     www.energyefficientbuild.com.


user HMCEH said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/39-1JWNfsOY)
Combining text between two different columns for all possible permutations

Trying to get the output in column C.
-Where every Sample Name (A2:A11)  is combined in text with every Time Point (B2:B5) to generate a new label.  In this case 10 samples x 4 time point to generate 40 unique data labels 
Tried basic fromulas from arrays, join, concatenate with little luck.  Appreciate anyone's help.
--------------------------------------------------------------------------------------------------
following is a solution to the problem