Duplicate Pivot Table Columns

[Norwood02062]

Hi all

I am trying to create a Pivot from Source Data that in many cases has the same column labels.
When I create the Pivot, a number is added to the duplicated column labels (Boston1, Boston2 etc.)
Is there a way to tell the Pivot to group these unique column labels that are duplicated many times (I would just like to see one instance of "Boston" as a column in the Pivot).

Thanks