Howdy everyone,

I'm having a problem in excel that I can't figure out, and I thought someone here might have a good solution.

Basically what I am trying to do, is take anywhere from 2-10ish columns of data, sort it, and have identical data lined up on the same row. The data will always be names.

For example....

The original data might look like:

Then after sorting it I'd like it to look like:

I can obviously sort each column one by one, and then drag it around to be lined up... but I didn't know if there was some simple function or macro that I wasn't aware of that would do what I want.

Thanks for any suggestions.