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
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
No comments:
Post a Comment