dynamical Merging rows and adding up sum

burkeam

New Member
Joined
Aug 19, 2023
Messages
7
Office Version
  1. 2021
Platform
  1. Windows
I have several table/tabs queried into a single worksheet. I'm trying to merge duplicate rows with the same "Part#" and sum to "Qty Rebuild" of those parts. The "Full Description" is not identical to each other and may be removed. In the end I'm looking for this list to only show a single row of duplicate "Part#" with the total Sum of "Qty Rebuild". As a kicker it would be nice to also get the sum of "QTY. Print"

I have attempted pivot table, Query and a little VBA. If the solution is VBA I might beed more description on what is going one


#9 Furnace rebuild list 08192023.xlsx
ABCDEFG
15711B6141051Proximity Sensor Bracket , Unload Gripper
15811B6141051Proximity Sensor Bracket , Unload Gripper
15911Pusher Rod - Ø1/2"-20 (Fine) Threaded Rod x 16 1/2" Length w/2 Nuts, Unload Gripper
16011Pusher Rod - Ø1/2"-20 (Fine) Threaded Rod x 16 1/2" Length w/2 Nuts, Unload Gripper
1611OnexSAFFIL LD MAT 1.33 X 24 X 582 (97 SQ FT/CTN)-3000 Degree polycristalline fiber for expansion joints and packing
16222F-310AFC HOLCROFTSL AUBURN F-310 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS
16388RS1803AFC HOLCROFTSL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS
16466RS1803AFC HOLCROFTSL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS
16588RS1803AFC HOLCROFTSL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS
16644RS1803AFC HOLCROFTSL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS
1673025OnexSuper Duty 9 X 4-1/2 x 3" #1 Wedge
168175160OnexSuper Duty 9 X 4-1/2 x 3" #2 Wedge
1694540OnexSuper Duty 9 X 4-1/2 X 3" #3 Wedge
17011D6090004Tooling Arm Assembly, 2 jaw gripper assy
17111D6090004Tooling Arm Assembly, 2 jaw gripper assy
Query1
 
I ended up finding a good solution through pivot tables.
Good to hear you found a solution.
If you would like to post that solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
 
Upvote 0

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Not sure how to post what was actually done but here are the pivot table fields and the report I needed


1692787472647.png
1692787503625.png
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top