Part # ADP WC Part# ADP WC
A 10 1 A ?
?
B 14 2 C ?
?
C 20 1 D ?
?
D 30 1 E ?
?
E 32 2 F ?
?

How to solve this in the same excel sheet ( the Part# list is huge ) ?
What would be the formula?

--
Thanks