If one of the values in a cell matches, I'm attempting to add up the values?

What I have now:

QTY TYPE GROSS WEIGHT NMFC CLASS
50 BOX 5 50 ii
30 BOX 2 50 ii
20 BOX 1 20 i

What I’m trying to make it look like:

QTY TYPE GROSS WEIGHT NMFC CLASS
80 BOX 7 50 ii
20 BOX 1 20 i

If NMFC is same, then it should be in one row.

Hi @SrikanthM,

To group values as show in you sample, use the group tagging element, where you’ll organize them based on the NMFC data field.

Check out our web tutorial for a simple demonstration of how to use it:

Let me know how it goes.