Hi
i have a table and want to filter by conditions, then group them by one column, then concatenate the remaining columns, then text join the rows and all of this in one single formual
So far i am able to do all the things except the Group by part
I am able to use the Powerquery to get the desired results.
I figured out how to sort and filter the data with the dynamic array formula.
For the 21.08 and machine B I can get to this result with the arrays (formual in cell J21)
The final result is combining rows and columns to this:
mix=22=full=21=mix=12=full=5
But i need this one
mix=34, full=26
SO the issues I can not solve by my own are:
How can i sum the scrap amount by the reasons for my selection in the array
So from this table
mix 22
full 21
mix 12
full 5
to this one
mix 34
full 26
Thanks
Bookmarks