J
johng
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?
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?