Forum Discussion
How to create a dynamic array based on the other cells
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.
Vijay_Uppala I'd suggest you look into Power Query, as demonstrated in the attached file. Connect to the Input Table with PQ, do several transformation and load the end result back to Excel as illustrated in the picture below. Add rows to the (structured) blue table. Press "Refresh All" on the Data ribbon and the green table (=PQ output) will update instantly.
Riny_van_EekelenThank you very much for the solution.
Unfortunately, I should have mentioned that I'm working on MAC and I dont believe Power BI is supported on MAC.
Can you think of any other solution?
Thank You
