fill in data in series

[KAleksiev]

Hello,

I hope you can be able to help me on this.

I have a list with unique numbers ( ex. 1,2,3,4...) and another list with data ( L1, L2, L3, L4).

I need to fill in an excel file with all data, to be like:

first row     Second row

1                 L1

1                 L2

1                 L3

1                 L4

2                 L1

2                 L2

2                 L3

2                 L4

and so on. 

Could you please advise>

Kind regards,

K.Alex

[#2]

@KAleksiev 

Here is a solution using Power Query: How To Generate All Possible Combinations Of Items From Two Lists 

[#3]

@KAleksiev 

As variant

with

=LET(
   rA, ROWS(listOne),
   rB, ROWS(listTwo),
   k, SEQUENCE(rA*rB),
   IF({1,0},
         INDEX(listOne,  INT( (k-1)/rB)+1),
         INDEX(listTwo, MOD(k-1,3)+1) )
 )