Help with Matching/Comparing Columns from Two Databases

Hello all,

I have a question involving two extensive databases (40,000+ cells) that don't match but are very similar with many exact cell matches, and getting them to arrange in alphabetical order and line up with spaces in breaks. The other issue is that list 2 has an associated set of columns after it.

Here's a simple example:

Please Login or Register  to view this content.

(The long explanation is that List A is a set of music track filenames and list B is the same set of tracks with some misspelled filenames, some missing files, and some additional files and business related values.)

The goal is to make List 2 and associated columns match with List 1 so that we can copy and paste the data in our databasing software.

For example:

Please Login or Register  to view this content.

So the goal would be to have spaces where the lists don't match up with the associated columns lined up as well.

Any advice or assistance would be greatly appreciated. Let me know how I can further clarify.

Thank you!