I guess I don't understand the question. Should just create the pivot with
ID in Rows and Question in Columns with Response in Data Fields, change Field
settigns to Average.

"johng" wrote:

Using Excel 2007, in pivot table, is there a way to put show detail for EVERY
cell?

Example: User has raw survey data consisting of one row per respondent;
includes ID, question and response.

ID....question....response
AB...Q1...91
AB...Q2...81
AB...Q3...71
CD...Q1...62
CD...Q2...52
CD...Q3...42
EF...Q1...33
EF...Q2...23
EF...Q3...13

User wants table like this.
ID.....Q1.....Q2.....Q3.....Avg
AB.......91.....81.....71...._81
CD.......62.....52.....42..._52
EF.......33.....23.....13..._23
Avg.._62...._52...._42

So in pivot table, is there a way to put show detail for EVERY cell? Or is
there another quick/easy way to create a table like the above?