Pivot tables are designed to manage numerical data, not text. There may be some complex formulas that could solve this, or it could be done with VBA programming. But you can't do it with a pivot table.