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

[DominicDcruze-oj]

Whoever is this miraculous lady, God Bless Her!

[kernoelnerd]

Myself: Writing a VBA function. Other youtubers: Bother Power Query. Karina Adcock: Hold my <preffered drink>! and give me LAMBDA.

[deemon]

Oh mah gawd I had no idea this kind of power was possible. I was blown away seeing you could create variables, but then a Lambda function, too!?!? 🤯🤯

[josestudyexcel]

You are an awesome teacher Karina. Thank you

[Evpat]

Wow, your brain is a beautiful thing. Thank you Karina!

[jazzista]

Great example on how to perform a Cartesian joint. A bit more involved than doing it in Powerquery however i wanted to see an excel option using dynamic arrays. Thanks for posting this great video

[HK-mzlb]

That's exactly what i've been looking for. Many thanks

[The_two]

Can you please make a video to make such all combinations for 3 or more columns.

[stevensonheriveaux]

Omg! life saver! exactly what i needed!

[haseebsadiq]

What an amazing video!!!! Hats off to you. Cant thankyou enough for this!

[SechabaMolefe-kvbn]

Wow, this is great. Thank you Karina, You have saved me lots of time for my report. can I be able to have three sets of data instead of two?

[BubblesNBaby]

This is a great time saver! Thank you!

[Ray-xjdc]

great video and to the point, saved me hours of googling :)

[noelrobinson]

Awesome tutorial, YOu may need a lozenges btw.

[danielvasquez]

I REALLY....REALLY NEED HELP WITH MY SITUATION, PLEASE! I have combinations in multiple cell blocks. I need to add a selection of numbers to all cellblocks while maintaining the correct numerical order of the combination. For example: I have cell blocks containing such combinations as: 03 05 09....15 17 21...ect and I want to add 2 even numbers say 2 and 4. How can I add to cell blocks making them 02 03 04 05 09, ect ??? BIG thanx!

[mickaelsflow]

Is it possible to learn this power... for Google Sheets?!

[PoojaMoulik]

How do I use this if my array has blanks? it not working in that case?

[CommanderAlistar]

Does this work on google sheets, and can I use this to combine 3+ lists?

[chandanmaity]

I am not able to copy the value produced. How can I copy?

[ahmedkhalil]

i do =A1:A4 & D2# is not work