Group Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ewcm - 09 Apr 2004 05:17 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Dave Hawley - 09 Apr 2004 06:33 GMT

Hi

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

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

Reply to this Message

Frank Kabel - 09 Apr 2004 08:29 GMT

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

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Have some problem in consolidating similar data:
>
[quoted text clipped - 22 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message