I am using Excel 2008 for Mac. I would like to have a cell generate a string based on the contents of the other cells on the same row.
For example, say I have the following table headers:
bob, weave, nip, tuck
And the next row (or could be any subsequent row) are multiplier numbers, for example:
2, 3, 1, 2
I would like the last cell on that row to generate a string based on the counts in each cell, the result would be:
"bob, bob, weave, weave, weave, nip, tuck, tuck"