Pivot Table adding "2" to value in answer set

Question

I have a simple table that I am pivoting.  Salesperson, territory, $$, expense type.  I am generating table to get total budget by salesperson.  What I am getting in the pivot table answer is a salesperson with a 2 added to end of name.  So "First Last-Name" is in my raw data and I am getting "First Last-Name2" in the pivot table.  I have tried changing the name to "First Last Name" and refreshing; it works fine.  I change the name back; result "First Last-Name2".  I have several sales people with hyphenated last names without a problem.  Anyone know why this is doing this?

Answer 1

For issues related to Pivot Table in excel, you may post your query at the forum below for better suggestions.

http://social.technet.microsoft.com/Forums/en/excel/threads

Answer 2

Thank you.