Pivot table and data issues!!! HELP PLease

[fantasyman]

Anyone!!!

I have been attempting to create some spreadsheets for fantasy football, to help better determine which players to draft. Anyways I have worked with excel many times before. However, the raw data I have that basically has all players from 2008 -14 listed in the spreadsheet. I have a different sheet for each position; RB, QB, and WR. But if I sort the players names A to Z, it lists the 2014 players first but below that it will list, for example: Adrian Peterson, all 2013,12,11,10,09, and 08 years before moving on to the next player. If that makes sense? Anyways I didn't think there was too much of an issue with that till I attempted to create a pivot table. The pivot table creates itself, but has the 2014 season players above all the other years rather than just all together. In my pivot table I have the names in the rows, seasons in the columns, then the players stats in the value. I am just wondering if anyone understands why my data is doing this. I have a few screenshots to better explain my dilemma. If anyone has any insight would be tremendous!!!!!

Thanks!!

 

[Jerry Sullivan]

Welcome to MrExcel,

Some of the cells that hold the year values may be formatted as Text instead of Numbers. An easy way to fix that is to insert a new column for the year field > format that column as numbers with no decimal places > then copy and paste the existing data as values only.

 

[fantasyman]

I did that, but for some weird reason it is still separating 2014 from the rest of the years. It makes no sense haha. For example, Aaron Rodgers is the first and if I sort the players by name, A to Z. It still puts only 2014 first. Then after all the players that played in 2014, it will show Aaron Rodgers again but listed for years 2013 through 2008. I don't understand why 2014 is being left alone at the top.

Thanks!
- FantasyMan