Combine all possible values and put them in columns

[diegie]

Hi guys, grils,

I have 6 columns in excel and every column has like 2 to 6 values.
I want to make all possible combinations, but not merged into 1 cell, but with still the 6 columns.
I need to import all possible combinations into a database for a webshop, so I need to contain these columns.

 

[shg]

There's a workbook at https://app.box.com/s/47b28f19d794b25511be with both formula and VBA methods to do that.