How to normalize comma separated values that are the same but were loaded in a different order
Hello, looking for some help. Is there an easy way to normalize the following table? The values in column B are all the same, they were just loaded in a different order. Is there a way to mass update so that these appear in the same order. The file itself contains many combinations…for example, there may be cells that have 3 comma separated values but each value is the same, just in a different load order. Or 4 values, in a different load order. Thank you in advance!!
Hello, looking for some help. Is there an easy way to normalize the following table? The values in column B are all the same, they were just loaded in a different order. Is there a way to mass update so that these appear in the same order. The file itself contains many combinations…for example, there may be cells that have 3 comma separated values but each value is the same, just in a different load order. Or 4 values, in a different load order. Thank you in advance!! Read More