Generate combinations for a variable number of columns in order

Hi everyone,

I was hoping someone would be able to guide me in the right direction... I'm going slightly batty here, and I'm pretty sure that without help, I'll wind up with a mess of While loops, while an alternative may be a much better idea.

I have a workbook that has one sheet, with several columns containing data, typically numbers and letters. The columns do not have to have the same amount of data as the others. I have another workbook that has a column that's meant to have the combinations of these.

However, the purpose of this file is to organize standards, and I'm hoping to be able to generate the proper combos. Here's an example of the columns (the number of columns can be variable...)

5 C 2
10 E 3
15 4


The combinations have to be in the same order as the columns... so the results would have to be like 5C3, 5E3, 10E4, etc. I've been searching for hours and have found nothing where the columns have to be the same order (with more than two columns).

Any guidance will be greatly appreciated! Thanks!

Lookup "CONCATENATION" and the "&" operator in Help.

There's a workbook that will generate these combinations using formulas at http://www.box.net/shared/ubd28tissi