Dear Sumit, Unique formula for combining and splitting the combination. =LET(_combinations,TOCOL(TOCOL(A2:A6&"|"&TRANSPOSE(C2:C6))&"|"&TRANSPOSE(E2:E4)), _divided,REDUCE({"Coffee","Milk","Size"},_combinations,LAMBDA(a,v,VSTACK(a,TEXTSPLIT(v,"|",,1)))), _divided) I hope you like it 🤗
I like the Power Query solution. Great video as usual. Thanks.
Toujours aussi formidable !😁
Hi Bro, your all tricks are useful... ❤ hats off
Thank you 😊
Great video, Sumit. As you said, I also think Power Query is the easiest way to solve the problem. Thanks for sharing the solutions.
Thanks Sir, for sharing such a valuable information. Amazing and awesome
Glad you found the video helpful Azhar 🙂
Need my coffee now! Also I’d love to buy you one. Think I had seen a link somewhere? Can you share 😊
Links available in description section!!!
@ thank you
Happy to see your videos after long years sir! Hope you are doing well! May god bless your teaching journey!
Thank you for the kind words Vignesh 🙂
Wow🎉
May be byrow will help to solve the problem
I tried BYROW, didn't work
@@trumpexcel is it possible to use recursive lambda
Maybe, haven't tried. Recursive LAMBDA's get complicated very quickly. I have an easier solution to this though. Will share in the next video
@trumpexcel thanks
Dear Sumit,
Unique formula for combining and splitting the combination.
=LET(_combinations,TOCOL(TOCOL(A2:A6&"|"&TRANSPOSE(C2:C6))&"|"&TRANSPOSE(E2:E4)),
_divided,REDUCE({"Coffee","Milk","Size"},_combinations,LAMBDA(a,v,VSTACK(a,TEXTSPLIT(v,"|",,1)))),
_divided)
I hope you like it 🤗
Thanks Jose... The solution I have for this is very similar to yours. Will show that in the video next week.