Combine data from multiple columns into one, separated by commas but without duplicates.
Hello! I currently have a very messy email audience list of nearly 14,000 that somehow has multiple duplicate fields. Basically, I need to consolidate the "Department" and "Major" columns into 1 of each. I've been toying with this issue for a while with some IF/THEN functions, but it gets tricky (for me, at least) when there are multiple departments/majors. I don't want duplicates in the Department/Major columns, but I do want non-duplicates pulled from the subsequent fields to be separated by commas. For example, in the 2nd row shown in the SS I would want the department cell to say "Library Studies, Interior Design" (rather than "Library Studies, Library Studies, Interior Design).
I essentially want Excel to do the following: if I is not blank and J+K are blank, don't mess with it. If I is not blank and does not contain the text in J+K, add the text from J/K to I, separated by a comma. If I is blank, fill with text from J (and from K, separated by a comma, if K does not contain the text in J). If I and J are blank, fill with column K.
Thanks in advance to anyone who can help out with this!
[link] [comments]
Want to read more?
Check out the full article on the original site