I liked how the posted solution did a trim with the Uppercase in the formula. I brought in a cleanse and a formula tool, so having both objectives done in one swoop would be better.
It seems 2015 Team Rank is missing from the original posted data set.
I also don't know enough about baseball, by Matt Duffy appears twice on the hitters data under 2 different teams. Then he is showing twice on the output so the total rows is one more than the initial Fantasy League Picks.