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?:

1	A
1	B
1	C
2	A
2	B
2	C
3	A
3	B
3	C
4	A
4	B
4	C
5	A
5	B
5	C

<tbody>
</tbody>

Thanks in advance for your support,
BR

Excel365

 

[sheetspread]

Try:

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

 

[JavierPeña]

it works!
Thanks!