I have a list of options
[TABLE="width: 500"]
<tbody>[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]white[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]blue[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]white[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
is there a way to use these existing date to populate/create a row in such way that it would be
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]red[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]blue[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]blue[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]blue[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
</tbody>[/TABLE]
I'm vaguely familiar with using Cartesian join through query however that would be multiplying list of product by set options resulting in productA,B of red(sml) white(sml)
****** id="cke_pastebin" style="position: absolute; top: 294px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]l[/TD]
[/TR]
</tbody>[/TABLE]
</body>
[TABLE="width: 500"]
<tbody>[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]white[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]size[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]blue[/TD]
[/TR]
[TR]
[TD]productA[/TD]
[TD]color[/TD]
[TD]white[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
is there a way to use these existing date to populate/create a row in such way that it would be
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]red[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]blue[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]blue[/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]blue[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
</tbody>[/TABLE]
I'm vaguely familiar with using Cartesian join through query however that would be multiplying list of product by set options resulting in productA,B of red(sml) white(sml)
****** id="cke_pastebin" style="position: absolute; top: 294px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]white[/TD]
[TD]s[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]m[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]l[/TD]
[/TR]
</tbody>[/TABLE]
</body>