Generate or Create all Possible Combinations from Two Column, Pair, List, using Excel Formula

Learn how to generate or create all possible combinations from two columns, pairs, or lists using Excel formulas.
I will teach you two Solution. Just watch and keep learning.
File Link: drive.google.c...

[@eeman17]

good one👍❤️

[@ucbakhtyar]

❤❤❤❤❤❤❤🎉

[@hagiasofia6179]

Nice video! As an alternative:
=LET(
values,B4:B13,
groups,D4:D6,
HSTACK(TOCOL(IF(SEQUENCE(,ROWS(groups)),values)),TOCOL(IF(SEQUENCE(,ROWS(values)),groups),,TRUE)))