Hi,

I have a data set as the following

ID ID2 String String2
1234 33423,43222,442224,213432 Sample; repeat; example; multiple second; possible; delimiter
2345 12354; 55633; 343534; 65443;121121 data;set; sample; find answer; combination; by




Now I want to find a Cartesian product of the following data set resulting in a data set with the same column headers but every possible combination of 1-4 columns from the next line of the headers

I have the following code which I was using to resolve the above problem. However, I could only perform Cartesian product for one row at a time. I am a newbie in vba and I tried all possible ways which I can think of to put the below code in a for loop but wasn't successful. Can anyone help me resolve this?

Please Login or Register  to view this content.

Or is there a way I could achieve this using SQL within excel?