Formula to get all combinations of two lists | Excel lambda

How to combine two lists together
=LAMBDA(array1,array2,
LET(txt,TOCOL(array1&"@"&TRANSPOSE(array2)),
HSTACK(TEXTBEFORE(txt,"@"),TEXTAFTER(txt,"@"))))

Microsoft Office 365, Beta Channel, Version 2304

• #science_technology
• #excel_lambda
• #lambda_excel
• #lambda_formula_in_excel
• #excel_lambda_formula
• #get_all_possible_combinations
• #all_combinations_from_two_lists
• #all_combinations_of_items_from_two_lists
• #all_possible_combination_of_values_from_two_lists
• #all_possible_combinations_from_two_lists
• #dynamic_array_formulas
• #office_365
• #excel_365
• #how_to_combine_two_lists_together
• #combine_lists_together
• #combine_two_lists_together