Hello,

I am trying to merge rows from a table that all have the same values in one of the columns.

Example:

Material, Order, # of Changes

4456,210412,0

4456,201443,3

4406,123456,5

4406,203034,2

4456,203530.1

The result I want is:

Material, Order, # of Changes

4456,(this column will be hidden),4

4406,(""),7

I just want to see the # of changes for each material, but I have to include the order somehow or else the # of changes is a ridiculously high number. Any help would be lovely!

Thank you.