I'm creating a pivot table in Excel 2007. What I'm trying to show are 4 columns, the first being the device names of a list of computers, the second being the corresponding device serial number. Where I'm having trouble is getting the serial number to show in my pivot table as a value, not a column heading or row heading. I want a column that says "serial number" and the list of corresponding values, not a count or sum.
Anyone know how to do this??