Group Data

[ewcm]

Have some problem in consolidating similar data:

Example in this stationary spreadsheet,

Project group Item Desc Qty
AAA Pencil 10
BBB Pencil 5
CCC NoteBook 20
DDD Pencil 18
EEE Paper A5 26


Want to group the above data to appear in spreadsheet as:

Item Desc Qty
Pencil 33
NoteBook 20
Paper A5 26


How to do that in Excel.

Appreciate if can advise.

thks

 

[Dave Hawley]

Hi


I would use a Pivot Table. If unsure about them, start here

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
I'd use a pivot table for that. See the following sites:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm