Hi,

Enter a row above the data with headings for each column. e.g.
ID Q1 Q2 Q3...

Then you will have something to Pivot.
In the PivotTable, drop Q1 and Q2 in the Data area. Then click on 'Sum of
Q1' and change it to average.

This seems a pretty trivial application for a Pivot Table. So perhaps you
should consider using worksheet formulas.
As in
=AVERAGE(B2:B40)
=STDEV(B2:B40)
etc.

Ed Ferrero
www.edferrero.com


I have reinvented the wheel by making a paper survey and then entering all
the answers into a spreadsheet. the format of the spreadsheet is; the
first
column is the id of every person surveyed and the next 9 columns are their
response to each of the 9 questions (responses are numbered so each
response
is a number from 1-8)each row is in reference to the answers that the
person
gave. so a typical row would be: PCA 1 6 1 2 2 1 5 8 1. pca being the ID
and
the other numbers being the response to the corresponding row's question.
The question is: how do i set up a pivot table to analyze the results.
please help me! (i can get the wizard started but i never end up with a
legible table)
--
thanks in advance