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
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!
Whoever is this miraculous lady, God Bless Her!
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!?!? 🤯🤯
Myself: Writing a VBA function. Other youtubers: Bother Power Query. Karina Adcock: Hold my ! and give me LAMBDA.
Wow, your brain is a beautiful thing. Thank you Karina!
You are an awesome teacher Karina. Thank you
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
That's exactly what i've been looking for. Many thanks
My god, you're a goddamn legend Karina!!!!!
Can you please make a video to make such all combinations for 3 or more columns.
I cracked up for 3 columns, have used another separator for the third column. It worked fine
Wow, mind blown. Thank you.
This is pure genius!
Omg! life saver! exactly what i needed!
What an amazing video!!!! Hats off to you. Cant thankyou enough for this!
This is a great time saver! Thank you!
great video and to the point, saved me hours of googling :)
Brilliant!
Awesome tutorial, YOu may need a lozenges btw.
Incredible !
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?
Brilliant, thank you
Bravissima! Grazie.
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!
How do I use this if my array has blanks? it not working in that case?
Is it possible to learn this power... for Google Sheets?!
I am not able to copy the value produced. How can I copy?
wow, genius
Does this work on google sheets, and can I use this to combine 3+ lists?
i do =A1:A4 & D2# is not work
What.....?