Excel 2007 : Data from 3 columns into Fourth column

[EsKay!]

Column A has numbers in cells A1 to A10

Column B has numbers in cells B1 to B276

Column C has numbers in cells C1 to C100

I want to create another column (Column D) which will include all possbile combinations of these 3 columns i.e in cell D1, I want A1-B1-C1, in cell D2 I want A1-B1-C2 ... up to A10-B276-C100.

What is the best way to do this?

[MarvinP]

Hi EsKay!

You are going to have 276 THOUSAND rows in Column D. What are you going to do with all that?

The best way to do this is to write a VBA Loop using 3 loopers. One for Col C, One for Col B and One for Col A.