Find similar value in rows for 2 columns and add the value for the 3rd column

[molf]

Hello everyone, which do you think is the most straight forward and quick way in filtering this data table.

I have 3 columns: Name, Type, Units
I need to find all similar values in column Name and Type, and add the units in the 3rd column and output it in one row.
for better understanding kindly see below table.

Thank you everyone

[Manish540 (Manish Shettigar)]

Check this workflow, input file and output file, @molf
Test_3.xaml (15.7 KB) Test.xlsx (9.1 KB) Out.xlsx (7.2 KB)

[molf]

I will and give you an update thank you

[Manish540 (Manish Shettigar)]

Okay