[KLUG Members] Need Spreadsheet Guru

[Adam Tauno Williams]

> > I have a politically important user who want to make a spread sheet that
> > takes data like -
> > Customer|Year|Sales
> > 2|2001|100.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
> He would use a Pivot Table. 

Eh, whatever.  I told him I didn't even know if it could be done in M$-Excel
(technically, a true statement).

> The OpenOffice equivalent (mostly, anyway)
> is the DataPilot. 

Yep, that did it.  Wow, I've never used DataPilot for that before - VERY NICE. 
I can even filter the data and everything.

Now I can think of a hundred other uses for that!