I have a problem which I don't know how to solve.. I have a list of part numbers and the location type in which these parts or stored on a warehouse. For example:
PART NO. LOCATION TYPE
S1039 H1
S1039 H2
S1039 H4
S1100 H1
S1100 H4
I would like to change the location type foe all the same part numbers to the same location type if the location type exists. For example, If "H2" exists, then change all the location types for "S1039" to "H2" since the "S1100" does not have a location type "H2", no changes would be made. Output would look like this. Of course this is simplified as my spreadsheet has almost 2000 lines.
S1039 H2
S1039 H2
S1039 H2
S1100 H1
S1100 H4
Thank you
PART NO. LOCATION TYPE
S1039 H1
S1039 H2
S1039 H4
S1100 H1
S1100 H4
I would like to change the location type foe all the same part numbers to the same location type if the location type exists. For example, If "H2" exists, then change all the location types for "S1039" to "H2" since the "S1100" does not have a location type "H2", no changes would be made. Output would look like this. Of course this is simplified as my spreadsheet has almost 2000 lines.
S1039 H2
S1039 H2
S1039 H2
S1100 H1
S1100 H4
Thank you