[KLUG Members] Need Spreadsheet Guru

[bill]

Hi Adam,

It's been a while, but I think a pivot table will lay out the data the 
way you want.

Putting a default zero in empty fields should be trivial, but those are 
famous last words... :-)

kind regards,

bill

Adam Williams wrote:

> 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
> 
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 
> 
>