Multiply rows

[JavierPeña]

Hi guys,

Sorry to bother you, but I don't know if Excel is able to do this task, if yes it would be great.

The thing is I have, for example, a list of values (1,2,3,4,5) and another list of values (A,B,C), is there any way, having this, to get these row combinations?:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance for your support,
BR

Excel365

 

[sheetspread]

Try:

https://app.box.com/s/47b28f19d794b25511be

 

[JavierPeña]

it works!
Thanks!