formula to merge and replicate 2 lists

[fizfed]

hi all,
i'm struggling with the following.

list 1 (nx1 structure -rows x columns)
x
y
z

list 2 (nx1 structure)
de
us
uk

desidered output (nx2)
x de
x us
x uk
y de
y us
y uk
z de
z us
z uk

while I now this can be done in Power BI, I wonder if there's a way to have it using some excel formulas.
could you please help?
thanks

[Glenn Kennedy]

Use:

=IFERROR(INDEX($A$2:$A$4,1+INT((ROWS(I$2:I2)-1)/3)),"")

and:

=IF(I2="","",IFERROR(INDEX($E$2:$E$4,1+MOD((ROWS(J$2:J2)-1),3)),""))

Next time, read the yellow banner (top of page) and act on its suggestions.

NB in Italy, you may need to use ; instead of ,