Pivot table values

[RW]

How do I get the value of data to show instead of the sum, count, min, etc?
I have a list of code values for items. The list contains A through L and 1
through 9. This is for thirty-two different sites and they do not all use
the same code for the same item. I am trying to display a matrix of the
items and the codes used by each site. When I add the code field to the data
items on my pivot table it will not diaply the actual code only the SUM etc.

 

[Jim Thomlinson]

Your question is a little thin but here goes.

Place the sites in the right most column. Place the codes across the top.
Place the codes in the data section. That should give you a Matrix of all of
the codes and which locations are using those code.

Note that pivot tables are designed to aggregate data. They are not designed
to show text.

 

[Herbert Seidenberg]

Excel 2007
This converts Pivot Table count data to
a Table with source text, using a macro.
http://www.mediafire.com/file/ww4mk0znmz5/02_27_09.xlsm