Excell combining files

[Merton porter]

I have two separate files both containing names, addresses, account
codes etc.

I want to merge the two files together so that the name address and
other information is all on the same line. There is more data in one
file than the other and I want it to roll to the bottom if it doesn't
match.

Example:
File1 File 2
ABC company, las Vegas ABD company, Kansas City
ABD company, Kansas City ABC company, Las Vegas

I want one file with one line showing ABC company merged with the file
to create one line of data for ABC Company.

Make sense?

 

[Earl Kiosterud]

Merton,

You can paste one under the other, then sort on the company column (which
will put the dups next to each other), then use a macro to remove the dups.
I think there's one at www.cpearson.com.