[KLUG Members] Need Spreadsheet Guru

[Adam Williams]

Ok, I'm beating my head against the wall for something stupid.

I have a politically important user who want to make a spread sheet that
takes data like -

Customer|Year|Sales
2|2001|100.00
2|2002|50.00
2|2003|75.00
10|2002|250.00
10|2003|375.00
15|2001|100.00
21|2002|175.00

and make a spreadsheet that looks like

Customer|2001|2002|2003

And fills in years without amounts with zero.

So far I haven't been able to come up with something.  There must be
some spreedsheet magic I don't know about since I'm sure I've seen this
done.

I'm using OOO1.1.x, he is using Excel 2000