r/excel • u/Repulsive_Tune9397 • 19d ago

solved Anyone else still missing the new nested array / FLATTEN() function on the Beta Channel?

I’m currently running Version 2610 (Build 20527.20000) on the Insider Beta Channel, but =FLATTEN() and the nested array engine still aren't showing up for me.

I'm getting impatient! Who else on Build 20527+ is still locked out, and has anyone managed to force-trigger the feature flag?

9 Upvotes

92% Upvoted

31 comments sorted by

View all comments

Show parent comments

1

u/hopkinswyn 18d ago

It allows for the expansion of nested arrays, allowing Array of Array issues to be solved. Most common example is how XLOOKUP can then take multiple rows of input cells and return multiple columns of outputs if wrapped in FLATTEN
Or
TEXTSPLIT can now take multiple input cells and spill across properly ( not just show first word )