I'm trying to find a way to copy the Qty from Column "C" and paste into
Column "D"
next to it's respective hardware cell(s). I hope the follwoing shows what
I'm trying to explain...

This is what I have:
A B C
D

Title Param Part Qty
D01 Part # 10-32 | BOLT, HEX DRIVE
D01 Part # 10-32 | COLLAR
D01 Qty 6
D02 Part # SPECIAL | NUT, CLIP-ON
D02 Qty 7
D03 Part # 1/4-20 | BOLT, HEX DRIVE
D03 Part # 1/4-20 | COLLAR
D03 Qty 8
D34 Part # 3/8" | BOLT
D34 Part # 3/8" | WASHER, PLAIN
D34 Part # 3/8" | BUSHING, PLAIN
D34 Part # 3/8" | WASHER, PLAIN
D34 Part # 3/8" | NUT, SELF-LOCKING
D34 Qty 2
D21 Part # 10-32 | WASHER, SPRING
D21 Part # 10-32 | WASHER, PLAIN
D21 Part # S.S | WASHER, PLAIN
D21 Part # S.S | NUT, HEX
D21 Qty 1
D26 Part # 5/16 | RIVET, UNIVERSAL HD
D26 Qty 8

This is what I'm trying to get to:
A B C
D

Title Param Part Qty
D01 Part # 10-32 | BOLT, HEX DRIVE 6
D01 Part # 10-32 | COLLAR 6
D01 Qty 6
D02 Part # SPECIAL | NUT, CLIP-ON 7
D02 Qty 7
D03 Part # 1/4-20 | BOLT, HEX DRIVE 8
D03 Part # 1/4-20 | COLLAR 8
D03 Qty 8
D34 Part # 3/8" | BOLT 2
D34 Part # 3/8" | WASHER, PLAIN 2
D34 Part # 3/8" | BUSHING, PLAIN 2
D34 Part # 3/8" | WASHER, PLAIN 2
D34 Part # 3/8" | NUT, SELF-LOCKING 2
D34 Qty 2
D21 Part # 10-32 | WASHER, SPRING 1
D21 Part # 10-32 | WASHER, PLAIN 1
D21 Part # S.S | WASHER, PLAIN 1
D21 Part # S.S | NUT, HEX 1
D21 Qty 1
D26 Part # 5/16 | RIVET, UNIVERSAL HD 8
D26 Qty 8

There can be as few as 1 or as many as 7 rows of hardware needed to copy
quantities to. I've tried pivot tables, but have not had any luck. Does
anyone know if this even possible with a macro?
Thanks for any help.
Tony