Match the number of A cells for the number of the cells in C

[ShadyLad]

Hello everyone,
So as shown below,
in A and B I have the model number, in C the color.
Is there a way to duplicate A and B for the number of C?
in our case 5015 wont change
6016 would be added 2 more time to match the 3 colors in C
and 7017 would be added just once
Is there a VBA that would help me here?

Thanks in advance

 

[awoohaw]

The solution I offer requires that you delete intervening blank rows.

You can use F5, find special cells, select blanks, OK
do nothing else
then type "=" & arrow to one cell up.
DO NOT PRESS ENTER......

PRESS CNTL-ENTR.

This will also fill your blank rows between sections though (which is why you need to delete them).
(or you could create a formula in all the blank cells that also checks to see if you have a color listed in the color column).