Pull all sizes all shoe code

I have the complete list of stock codes on column A

Column C is my query without size

Column E is my expected results that i copy pasted manually

The practical story of this is that around 50 codes were brought to office for selection ,
now since they have been selected I want to supply to the selector all sizes of selection
from the long list , If i don't have a macro I have to manually copy paste selection

result in sheet2



Kind regards
Leo

Awesome , Leo Taxi , My god it will do the needful on even 10,000 rows
Tons of time saved