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
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 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
157 | 1 | 1 | B6141051 | Proximity Sensor Bracket , Unload Gripper | |||||
158 | 1 | 1 | B6141051 | Proximity Sensor Bracket , Unload Gripper | |||||
159 | 1 | 1 | Pusher Rod - Ø1/2"-20 (Fine) Threaded Rod x 16 1/2" Length w/2 Nuts, Unload Gripper | ||||||
160 | 1 | 1 | Pusher Rod - Ø1/2"-20 (Fine) Threaded Rod x 16 1/2" Length w/2 Nuts, Unload Gripper | ||||||
161 | 1 | Onex | SAFFIL LD MAT 1.33 X 24 X 582 (97 SQ FT/CTN)-3000 Degree polycristalline fiber for expansion joints and packing | ||||||
162 | 2 | 2 | F-310 | AFC HOLCROFT | SL AUBURN F-310 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS | ||||
163 | 8 | 8 | RS1803 | AFC HOLCROFT | SL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS | ||||
164 | 6 | 6 | RS1803 | AFC HOLCROFT | SL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS | ||||
165 | 8 | 8 | RS1803 | AFC HOLCROFT | SL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS | ||||
166 | 4 | 4 | RS1803 | AFC HOLCROFT | SL AUBURN F-610 ELECT. FEEDTHROUGH 5/8"-11 THREADS BOTH ENDS W/4 JAM NUTS | ||||
167 | 30 | 25 | Onex | Super Duty 9 X 4-1/2 x 3" #1 Wedge | |||||
168 | 175 | 160 | Onex | Super Duty 9 X 4-1/2 x 3" #2 Wedge | |||||
169 | 45 | 40 | Onex | Super Duty 9 X 4-1/2 X 3" #3 Wedge | |||||
170 | 1 | 1 | D6090004 | Tooling Arm Assembly, 2 jaw gripper assy | |||||
171 | 1 | 1 | D6090004 | Tooling Arm Assembly, 2 jaw gripper assy | |||||
Query1 |