Forum Discussion
WrapRows2Dλ / WrapCols2Dλ: Fast, efficient 2D wrapping without flattening
Looks like very impressive work with lots of error checking and such. I will have to dig into it but I was wondering if you did time tests on this as compared to the flattening approach. I suppose when it will matter the most will be with extrememly large set in which case the number of rows might become a limitation. But then again, does the number of rows limitation even apply to arrays in calculations?
From the start my approach was to avoid flattening the input array. I have several other functions in my library that use pure i/j indexing and the times are always fast (Especially when thunked. Excel will not evaluate 'i' or 'j' twice but only when used within INDEX(array,i(),j() for example ).
I try to avoid Lambda helpers for re-shaping.
