Combination of three lists

[diarrheaplanet]

Hey guys,

Another thing I'm trying to do over here:

I have three lists of data like this:

[TABLE="width: 200"]
<tbody>[TR]
[TD]Lis 1[/TD]
[TD]List 2[/TD]
[TD]List 3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]c
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]aa[/TD]
[TD]cc[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]ccc[/TD]
[TD]ccc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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


[TABLE="width: 200"]
<tbody>[TR]
[TD]Lis 1[/TD]
[TD]List 2[/TD]
[TD]List 3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]c
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]cc[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]ccc[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]aa[/TD]
[TD]c[/TD]
[/TR]
</tbody>[/TABLE]

...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)