Forum Discussion
Rack of Lambda
There’s been a lot of content shared recently to commemorate the upcoming 40th anniversary of Microsoft Excel. Personally, I’ve only been using Excel for around half that time, but October also marks...
I was studying your rack of lambda formulas and trying to understand how they works. UNPIVOT() formula is really cool. However, could you write a generic lambda formula to unpivot delimited words (comma or any other delimiter) as well as unpivot based on numbers given. Attached is an sample input and desired output. I can achieve this by a complex long formula using REDUCE() and combination of few other formulas. I would expect something like =UNPIVOTDELIMITER(B4:C6,D4:D6). Here B4:C6 is row label and D4:D6 is delimited words. Same for second example like =UNPIVOTBYNUM(B14:C16,D14:D16). Any better changes/features is highly appreciated.