Forum Discussion
Solved
How to create a dynamic array based on the other cells
Hello, I have a requirement where i need to populate the entries based on an input table. The input table below has 2 columns, VM Type and # of VMs, basically it tells how many VMs are there for ea...
I have added a couple of dynamic array solutions to Riny_van_Eekelen 's Power Query solution. The second uses Lambda functions for the accumulation and most likely is not available to Vijay yet.
I have added a couple of dynamic array solutions to Riny_van_Eekelen 's Power Query solution. The second uses Lambda functions for the accumulation and most likely is not available to Vijay yet.
The dynamic array solution works really well.
I couldn't get the Lambda function to work, but, as you stated, may be it is not available on Mac.
Thank you very much for all your help.
