[KLUG Members] Need Spreadsheet Guru

[Tony Gettig]

bill wrote:
> Hi Adam,
> 
> It's been a while, but I think a pivot table will lay out the data the 
> way you want.

I think Bill is right. Pivot Table in Excel will probably do what you 
want to do. I can never seem to get it right the first time though...it 
usually takes a few times dragging and dropping the data around in the 
wizard to make it look the way you want.

Does OOO have an equivalent functionality? I just scratch loaded this PC 
and can't check, but I can tomorrow.

> 
> 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

Tony Gettig
http://gettig.net