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