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!
