List All Possible Combinations (without Power Query) on a Mac

[redhots4]

Hi everyone. I have three columns: Name, College, and Term. I want to create a list of rows showing all the combinations of the three. Raw data and the desired output is shown. I've researched using Power Query to do this but I'm on a Mac and to my knowledge it's not an available feature on this platform. Thanks!!

Clin Out Sum 08042022.xlsx
	A	B	C
1	Name	College	Term
2	Andy	KU	Spring I
3	Mary	CU	Spring II
4	Tom	NU	Summer
5	Jerry	UTA	Fall I
6	Beth	UCLA	Fall II
7		UF
8
9	Desired Output
10	Name	College	Term
11	Andy	KU	Spring I
12	Andy	CU	Spring I
13	Andy	NU	Spring I
14	Andy	UTA	Spring I
15	Andy	UCLA	Spring I
16	Andy	UF	Spring I
17	Andy	KU	Spring II
18	Andy	CU	Spring II
19	Andy	NU	Spring II
20	Andy	UTA	Spring II
21	Andy	UCLA	Spring II
22	Andy	UF	Spring II
Sheet4

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Name	College	Term
2	Andy	KU	Spring I
3	Mary	CU	Spring II
4	Tom	NU	Summer
5	Jerry	UTA	Fall I
6	Beth	UCLA	Fall II
7		UF
8
9	Desired Output
10	Name	College	Term
11	Andy	KU	Spring I
12	Andy	KU	Spring II
13	Andy	KU	Summer
14	Andy	KU	Fall I
15	Andy	KU	Fall II
16	Andy	CU	Spring I
17	Andy	CU	Spring II
18	Andy	CU	Summer
19	Andy	CU	Fall I
20	Andy	CU	Fall II
21	Andy	NU	Spring I
22	Andy	NU	Spring II
23	Andy	NU	Summer
Main

Cell Formulas
Range	Formula
A11:C160	A11	=LET(data,A2:C7,r,ROWS(data),c,COLUMNS(data),m,MID(BASE(SEQUENCE(r^c,,0),r,c),SEQUENCE(,c),1)+1,d,INDEX(data,m,{1,2,3}),FILTER(d,MMULT(--(d=""),SEQUENCE(c,,,0))=0))
Dynamic array formulas.

 

[redhots4]

How about

Fluff.xlsm
	A	B	C
1	Name	College	Term
2	Andy	KU	Spring I
3	Mary	CU	Spring II
4	Tom	NU	Summer
5	Jerry	UTA	Fall I
6	Beth	UCLA	Fall II
7		UF
8
9	Desired Output
10	Name	College	Term
11	Andy	KU	Spring I
12	Andy	KU	Spring II
13	Andy	KU	Summer
14	Andy	KU	Fall I
15	Andy	KU	Fall II
16	Andy	CU	Spring I
17	Andy	CU	Spring II
18	Andy	CU	Summer
19	Andy	CU	Fall I
20	Andy	CU	Fall II
21	Andy	NU	Spring I
22	Andy	NU	Spring II
23	Andy	NU	Summer
Main

Cell Formulas
Range	Formula
A11:C160	A11	=LET(data,A2:C7,r,ROWS(data),c,COLUMNS(data),m,MID(BASE(SEQUENCE(r^c,,0),r,c),SEQUENCE(,c),1)+1,d,INDEX(data,m,{1,2,3}),FILTER(d,MMULT(--(d=""),SEQUENCE(c,,,0))=0))
Dynamic array formulas.

I get a #SPILL! error with that formula when pasted into A11.

 

[redhots4]

I was able to sort it out! Thank you! Marking as solution.

 

[Fluff]

You're welcome & thanks for the feedback.