Oct 05 2021 12:05 AM
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
Oct 05 2021 01:24 AM - edited Oct 05 2021 01:24 AM
Here is a solution using Power Query: How To Generate All Possible Combinations Of Items From Two Lists
Oct 05 2021 03:54 PM
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) )
)