Tom Farrar
asked on
Combining Excel Rows Into One Row..
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
ASKER
I'll check the articles out! Thanks.
ASKER