Combination of three lists

[diarrheaplanet]

Hey guys,

Another thing I'm trying to do over here:

I have three lists of data like this:

Lis 1	List 2	List 3
1	a	c
2	aa	cc
3	ccc	ccc

<tbody>
</tbody>

Is there anyway that I could get all the possible combinations in the table in three diferent columns? Something like this:

Lis 1	List 2	List 3
1	a	c
1	a	cc
1	a	ccc
1	aa	c

<tbody>
</tbody>

...and so forth

Any ideas or help is greatly appreciated!

 

[mart37]

place in row 2: =INDIRECT("B"&INT((ROW()+1)/3)+1)
and in the next column: =INDIRECT("C"&ROW()-(INT((ROW()+1)/3)-1)*3)