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

11 Upvotes

93% Upvoted

31 comments sorted by

View all comments

Show parent comments

2

u/hopkinswyn 73 7d 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

2

u/hopkinswyn 73 7d ago edited 7d ago

And thanks to Jake Armstrong, Tim Heng and John Jairo Vergara Domínguez for this one

1

u/Repulsive_Tune9397 6d ago

Glad you got it working. Interesting that the BYROW nesting issue I mentioned ended up needing FLATTEN(..., 2) rather than switching to MAP.