Summarize

[Theo L]

Hello,

I am trying to make a history analysis out of expedition records. Th
data I am using is given per shipment, that means that on one da
multiple shipments can go to one customer. See the example:

Date Year Week Customer 1
Customer 2 Customer 3
24.09.2004 2004 39 1750
24.09.2004 2004 39 22750
24.09.2004 2004 39
25.09.2004 2004 39
27.09.2004 2004 40 13500
27.09.2004 2004 40 10500
27.09.2004 2004 40 30000
27.09.2004 2004 40
27.09.2004 2004 40
27.09.2004 2004 40
27.09.2004 2004 40
28.09.2004 2004 40 15750
29.09.2004 2004 40 1500
29.09.2004 2004 40 33000
29.09.2004 2004 40 33000

This sheet is 1600 rows and 15 colums large. It is from the begin o
2002 untill the end of 2005.

What I want is from every customer the outgoing quantities, summarise
per week, not per shipment. Something like:

Year Week Customer 1 Customer 2 Customer 3
2004 39 24500
2004 40 121500

Does anybody know a solution which doesn't need a lot of manual adding

 

[David McRitchie]

Hi Theo,
This is ideal data for a Pivot Table.
DataPig Excel Training (flash file presentations)
http://www.datapigtechnologies.com/ExcelMain.htm

Contextures -- Excel Tips and Techniques
http://www.contextures.com/tiptech.html

 

[Theo L]

Thank you, this looks like it might solve my problem. I'm going to tr
it out