I am trying to duplicate row based on a list.
example
my 1st list contains
A
B
C
D
E
and I want it to multiple by the 2nd list
1
2
3
so the end result that i hope to get
A 1
B 1
C 1
D 1
E 1
A 2
B 2
C 2
D 2
E 2
A 3
B 3
C 3
D 3
E 3
Thanks in advance. I am ok to use access