Pivot Table Primer

[Rich]

Hi,

I have a worksheet with product sales by branch which looks like this (very
simplified, thousands of rows of data)

Branch Product Sales Value Refund Value
town1 widget a 445 0
town2 widget a 1345 23
town3 widget a 5643 0
town1 widget b 333 0
town2 widget b 664 0
town 3 widget b 332 0


etc,


I want it to look like:-

widget a sales widget a refunds widget b sales widget b
refunds
Town 1 445 0 333
0
Town 2 1345 23 664
0
Town 3 5364 0 332
0


I "think" Pivot Tables are the solution, but not really used them, can
someone confirm this is the best way, or point out a better way, and can
anyone recommend a really good online Pivot Table primer ?

 

[Ed Ferrero]

Hi Rich,

A Pivot Table will work for you.
Look here
http://www.edferrero.com/ExcelTutorials/tabid/54/Default.aspx
and here
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Ed Ferrero
www.edferrero.com

 

[Dave Peterson]

Some more:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[Rich]

Some more:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

Thanks Ed and Dave,

Those links are great, I'm a lot further forward now.