Combining Duplicates

[LordDragon]

Greetings,

I have a page with 3 columns and an unknown number of rows. There is a header row at the top. This is an order sheet for parts. The items being added come from several lists, with some duplicate parts.

What I need is to take any duplicate parts (based on part number) and combine the quantities so the item is only on the list once, but the correct quantity is listed.

For example:

Part Name	Part Number	QTY Needed
Cable Comm 422 150ft	CBLASS174	6
Cable Comm 422 40ft	CBLASS446	1
Label, Cable ID, Do Not Unplug	LBL468	3
Label, Cable ID, Do Not Unplug	LBL468	7

<tbody>
</tbody>

Notice the duplicate parts. I want to be able to make this be:

Part Name	Part Number	QTY Needed
Cable Comm 422 150ft	CBLASS174	6
Cable Comm 422 40ft	CBLASS446	1
Label, Cable ID, Do Not Unplug	LBL468	10

<tbody>
</tbody>

Thanks.

 

[Marcelo Branco]

Try a Pivot Table

Part Name and Part Number ---> Row Labels
QTY Needed --> Values area

Click inside the Pivot Table
Design > in Layout group click in Report Layout and pick Show in Tabular Form

Done!

	A​	B​	C​
1​
2​
3​	Part Name​	Part Number​	Sum of QTY Needed​
4​	Cable Comm 422 150ft​	CBLASS174​	6​
5​	Cable Comm 422 40ft​	CBLASS446​	1​
6​	Label, Cable ID, Do Not Unplug​	LBL468​	10​
7​	Grand Total​		17​

<tbody>
</tbody>

Hope this helps

M.