Finding all combinations from two lists

[andreaa90]

Hi! I am looking for help trying to generate all possible combinations of items from two lists. Please see attached image for an example of input an output. Thank you so much for your help!

 

[JamesCanale]

MrExcelPlayground14.xlsx
	A	B	C	D	E	F	G	H
1	List 1	List 2
2	A	1
3	B	2
4	C	3
5
6	Output 1	Output 2	Output 3	Output 4	Output 5	Output 6	Output 7	Output 8
7	1	A	1	A	1	A	1	A
8	B	2	2	B	B	2	2	B
9	C	C	C	3	3	3	3	C
Sheet17

Cell Formulas
Range	Formula
A6:H6	A6	="Output " & SEQUENCE(1,2^ROWS(A2:B4))
A7:H9	A7	=LET(z,A2:B4,x,ROWS(z),y,SEQUENCE(x),a,SEQUENCE(x,2^ROWS(z)),b,SIGN(BITAND(MOD(a-1,2^x)+1,(2^(y-1))))+1,c,INDEX(z,y,b),c)
Dynamic array formulas.

 

[andreaa90]

Awesome! Thank you so much!

 

[Eric W]

Another option:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G	H
1	List 1	List 2
2	A	1
3	B	2
4	C	3
5
6	Output 1	Output 2	Output 3	Output 4	Output 5	Output 6	Output 7	Output 8
7	A	A	A	A	1	1	1	1
8	B	B	2	2	B	B	2	2
9	C	3	C	3	C	3	C	3
Sheet3

Cell Formulas
Range	Formula
A7:H9	A7	=LET(rng,A2:B4,r,ROWS(rng),s,SEQUENCE(r),INDEX(rng,s,MID(DEC2BIN(SEQUENCE(,2^r,0),r),s,1)+1))
Dynamic array formulas.