Re: Variable number of multiple rows per record; want summary by record

TR
It looks like the sort of thing a pivot table could handle. It isn't
clear, tho, what the two columns after the names represent. Are they
different things (Wins and Losses) or the same (Bananas)?

Assuming that they are different, give each column a header. (eg Name,
Win, Loss)
Select all rows & columns with data (including header)
Data>PivotTable Report...
Step 1 - where is data? choose Excel list or database
Step 2 - should already show the range containing the data
Step 3 - where to put table, choose New Work***
click on Layout
Drag the "Name" label to the Row box
Drag the "Win" label to the Data box. It will say "sum of Win". Double
click "sum of Win"
Choose Average instead of sum. Format if you want.
Do same with "Loss".
Ok. Finish.

There are more bells and whistles, but this is the basic idea.
Just don't trust the "standard deviation" option (see my recent post).

If ColB and ColC are really the same sort of quantity (bananas), it can
still be done, but is a bit trickier. You have to display COUNT of each
column in the pivot table and do some math to find the overall average.
Too complicated for this post.

jpdphd

TR wrote:
Here's what the data look like

Pat 10 20
Joe 15 10
Joe 8 11
Kay 9 32
Pat 14 17
Joe 33 11

In short, each person has from 1 to n rows of data.. I want a summary
(probably on a different ***) that shows the mean for each person.
The new *** will have one row per person, showing the mean for each
data column for that person.

Suggestions?

TIA

.