So I have the following data example in three consecutive rows:
Tom, Kansas, 321 N B, University
Tom, Kansas, 321 N B, University, Wichita
Tom Farrow, Kansas, 321 N B, Kansas University
I'd like to have one row that eliminates duplication. It would look like this (knowing there is still some duplication due to similar, but different naming conventions between the commas).
Tom, Tom Farrow, Kansas, 321 N B, Kansas University, University, Wichita
Will an Excel function do this? Thanks. - Tom