I have raw data from a supplier's excel catalog. They list an item's available sizes (in a column) in the following different values (and many others):
S, S - M, S/M, S - L, S - 2XL, S/M - M/L, 2XL, 2XL - 3XL, 2XL - 6XL...
You get the idea. Is there a good way to insert, look up, or assign the size values I want (S-XL,2XL,3XL,4XL,5XL,6XL) based upon the "Size Range" values they use?
Or, alternately, a good way to sort or manipulate the data into a more look-up-able form?
I've attached a file if you need more clarity.