Sorting data in a pivot table/ removing duplicate names from slicers

I have a pivot table with two issues:

1.) I'd like to be able to sort the data below the slicers by the heading categories (in the attached pivot table, those would be the row headers such as "Contract Number," "Stardate 2375 Fees," etc).

2.) There are repeat names in the slicers- see for example in the "National Manager Name" slicer, "Mr. Spock" appears twice. Is there a way to combine them into one? Can anyone figure out why two of the same name shows up to begin with? It's not a matter of spelling or spacing, so I just can't understand why.

The real spreadsheet is 2,800 lines long so I made a smaller spreadsheet with fake data.

Thanks!

1.) What do you mean by "to the left of this field?" (I.e. what are you calling "this field?")

2.) Thanks- I suspect that is the problem with the real spreadsheets :-)

I guess I'm not understanding what you're trying to say, then.

What I wish to do is have all the following be sortable:

Contract Number
Linked Contract #(s)
Contract Name
"Asset Balance as of Nov 29, 2013

Stardate 2375 Fees
Stardate 2376 Fees, Asset-Based
Stardate 2376 Fees, Dollar-Based
"Impact of fee increase
as of Stardate 2376"
Net fee reduction- Asset-based
Net fee reduction- Dollar-based
Starship Financial Institution (SFI) Name
SFI ID #
"Fee Increase Offset
"Customer Service Agent


(These are all the columns I selected as "row headers."

Is it possible for all of these to be sortable?

Thanks

1.) I think maybe I understand what you're trying to say now-- are you saying that the only field you can sort by is the very leftmost field, and you cannot sort by any of the other fields?

2.) Is there a way to use VBA code to work around this issue and make all the fields sortable?

Thanks so much

When I tried sorting, I could _only_ sort by the Contract Number field and no other fields. I guess I still don't understand your answer. Can you try simplifying the language a bit? I'm new to making pivot tables


Thanks