Help summarizing by item with more than one matching result

Question

Hi I have the following table below and would like to re-order this so that plant(s) are on one line. Second table in red is how I'd like it to read. Any help would be great!

MaterialRatio 1Ratio 2Plant 1Plant 2A20  2A 801

MaterialRatio 1Ratio 2Plant 1Plant 2A20 80 12

messi007 · Answer

@moblender,

Another methode :

With that if you have a new column it will appear in the output without modifying the workflow.

Attached the workflow,

Regards,

SUM_20220131.yxmd

binu_acs · Answer

@moblender use a summarize too for this