Thanks everyone for all the help, but none of the solutions are working correctly.
JBeaucaire, I like the elegance of your solution, but the results aren't accurate. For instance, line 1 shows this:
Abaddon Adolf Hitler Darth Vader Darth Vader
I'm assuming this is in order of Big Boss>Smaller bosses. Darth Vader doesn't supervise himself.
Also, this line:
Frankenstein Elvis Darth Vader
Frankenstein doesn't supervise anyone.
Blane,
On your spreadsheet you show Thomas Edison in the same column with Abaddon. No one supervises Abaddon. Abaddon supervises Adolf, Adolf supervises Thomas Edison, Thomas Edison supervises a host of folks.
In any solution, Abaddon should be by himself, then everyone else either reports to him or to someone under him. There's got to be a way to do this, but I'm getting stumped. I appreciate you all trying.
Bookmarks