| I realize you've already solved your problem, but in case anyone else is wondering about a similar problem, I think you can use a formula which uses the ampersand (&) symbol to combine values from different cells.
So for example, if "blue" is in A1 and "trips" is in B1, you can type
=(A1&B1) into column C and it will combine values into "bluetrips".
(and then fill down as appropriate).
Anyway, hope that helps!
__________________
=============
"Success is a lousy teacher. It seduces smart people into thinking they can't lose." (Bill Gates) |