Help summarizing by item with more than one matching result

[moblender]

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!

Material	Ratio 1	Ratio 2	Plant 1	Plant 2
A	20			2
A		80	1

Material	Ratio 1	Ratio 2	Plant 1	Plant 2
A	20	80	1	2

[binu_acs]

@moblender use a summarize too for this

[messi007]

@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,