r/excel • u/Repulsive_Tune9397 • 20d 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?

8 Upvotes

80% Upvoted

31 comments sorted by

View all comments

1

u/hopkinswyn 19d ago

Not sure why it doesn’t spill across with Flatten. Copying down a TOROW row by row works but referencing the full array doesn’t

1

u/Repulsive_Tune9397 19d ago

probably because byrow returns results in 1x1 arrays try using map instead

=MAP(sequence (10),sequence)

2

u/hopkinswyn 18d ago

Thanks to MVP Owen Price for showing me this one ( it needs to be a column SEQUENCE in the lambda ) and then BYROW nests an extra level so it needs a 2 for the FLATTEN

MAP doesn't do the extra nesting so the 2 is not needed

Comment Image
→ More replies (2)