Debra:

That did it. Thanks for all your help. You're fantastic.

jnix

"Debra Dalgleish" wrote:

Try to change the date field in the wizard:

Right-click on a cell in the Pivot Table
Choose Wizard
Click the Layout button
In the Data area, double-click the 'Count of Date' button
For Summarize by, choose Sum
Click OK, click OK, click Finish

jnix wrote:
All of the date fields just have a "1" in themn because they're a count
field. Formatting them for date just gives1/1/01. Now what?
Thanks,
jnix

"jnix" wrote:


Debra:
More information. In the Data Area, it says Count of Date and Count of
Amount and
Thanks,
jniix

"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