MicrosoftI apologize if I was a little strident in the way I questions the point of the proposed new function. I use array shaping and stacking a lot as an integral part of my algorithms but that is always with structured references or named ranges that define the extent of the data object precisely. I realise other people work differently.
One of the reasons I answer questions on a number of forums is to gain insight into the rich mix of problems that users encounter. The problem I then have is whether to demonstrate the applicability of the methods I embrace or to adopt methods that I hate but the OP might actually use. My decision is to stick to my guns and demonstrate solutions I am happy with, rather than looking at my own work and wanting to disown it. Fortunately, others are more flexible!
I find it fascinating that the pace of change in Excel has been so rapid over the past few years that the majority of Excel users do not even recognise a 365 solution as having anything to do with spreadsheets; where do I put the code has been asked on a number of occasions whilst eyes glazing over and moving to another solution is commonplace. Nevertheless, things are gradually changing as more users are getting to grips with dynamic arrays, even though LET and LAMBDA seem to be regarded as methods of last resort rather new foundations that permit richer solutions.
