pivot table data not coming up properly :(

[SimonLee]

hi i am having problem with this file...please see attached. the data on the DEF FP Year 2013-2015 worksheet for column D is not aligned up with the data in column B and C. I can't figure out what is causing this problem...thanks for the help guys..

[Pete_UK]

If you select cell A5 of your pivot table (Arizona Cardinals), then click in the right hand part of the formula bar, you will see that the cursor is butted right up to the s at the end of the name. Select cell A6 and do the same - you can see that there is a space (a normal space this time) at the end of the name, and in all your raw data you have a space at the end of the names for 2013 and 2014, but this space is not present for the 2015 data. Excel sees these as two different names. As it is a normal space (you can verify this using the CODE function), you can use the TRIM function to remove them, or manually add a single space at the end of the names for the 2015 data to make them all the same.

Hope this helps

Pete