Excel - Pivot tables - Multiple values for single cell

Question

I have a pivot table.  Techs are listed as the table rows and Dates are listed as the table columns. The value is a store number.  Usually, a tech can work at one store per date, but occasionaly, a tech can be at two stores per day.  is there any way that a single cell in the pivot table can show both store numbers in the cell, rather than either the first or last? 

Rearranging the table so that the stores are column headers and the dates are the values is not an option.  Management wants to see the timeline. 

Any help or ideas would be greatly appreciated.

Answer 1

I don't think so.  If the data is coming from more than one cell it will either be counted or summed by default. 

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire