Hello Helpful People,

I want to combine several years worth of baseball stat sheets for analyis. Stat sheets are done by year, so I can get an Excel sheet with 2009 stats for every player, another with the 2008 stats, and so on. I want this all in one sheet with all the data kept separate, and it would look something like this: Column A is the player's name. Column B is the player's position. Columns C through H would be 2009 stats in various categories. Columns I through N would be the same categories but for 2008, and so on.

The problem for me is that each year there are different players playing baseball. There's a lot of overlap, but it isn't anywhere near perfect. I'd want blanks to appear in cells that correspond to stats from years a player did not play.

Also, I've found a site that assigns unique codes to each player, which avoids the problem of having multiple players with the same name.

Is there any way to do what I'm trying to do? I'm fairly handy with a lot of Excel functions, but this one has me stumped.

Thanks for any help you provide.