Right-click on one of the Date column headings
Choose Field Settings
Choose to Summarize by: Sum
Click OK

Do the same for the Amt field.


jnix wrote:
Debra:
Thanks. It works pretty good until I get to the pivot table. The table just
gives me columns headed by different counts and then has "1" in each column
where there was something in the table.

What didi I do wrong?
Thanks,

jnix


"Debra Dalgleish" wrote:


You could add a column to your table, to count the donation occurrence,
then use a pivot table to summarize the data.

For example, in cell D1 enter the heading DonationNum
In cell D2, enter the formula: =COUNTIF($A$1:A2,A2)
Copy the formula down to the last row of data.

Select a cell in the table, and choose
DataPivotTable and PivotChart Report
Click Next, check the data range, click Next
Click the Layout button
Drag DonorID to the Row area
Drag DonationNum to the column Area
Drag Date and Amount to the Data area
Click OK, click Finish

Drag the Data button to the right, to arrange the data horizontally
If necessary, drag the Donation button to the left of the Data button
You may have to format the date columns.


jnix wrote:

I have a spreadsheet as follows:

DonorId Date Amount
1 5/4/04 100
1 7/5 04 50
2 1/5/04 200

I'd like to change it to:

DonorId Date Amount Date Amount
1 5/4/04 100 7/5/04 50
2 1/5/04 200
3

There are about 3,700 rows and the number of dtes per donor vary.

Any ideas oon how I can do this?

Thanks,
jnix



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html