We are redoing the category structure of our website. Some products live in multiple categories, so the field will contain 2 or more category IDs like 1234,5678 or 90,123,4567. I have a lookup table of what the new values should be, but some of the categories are also going away.
I have data in cell S1:T7 (column S contains units and column T contains quantity)
what i want in cell U1 is a...