Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This worked! Thank you so much for your help! I really appreciate it.