Generating new data based on cell value

Hello all!
Could you please help me with this problem - I need a vba macro that will generate new data based on a cell value. For example:
This is what I have
Model;Sizes;
J-1;0-14;
J-1;0-24;
J-2;0-14;
J-3;0-14;
J-4;0-14;
J-4;0-24;
J-5;0-24;

And this what I want to have:
J-1;0;
J-1;2;
J-1;4;
J-1;6;
J-1;8;
J-1;10;
J-1;12;
J-1;14;
J-1;16;
J-1;18;
J-1;20;
J-1;22;
J-1;24;
And so on for the other models.

Some models are represented in both 0-14 and 0-24 sizes, that's why after all sizes have been generated they also need to be checked for duplicates and delete them if found.

Attached file has the above example with full details on final results

Thank you very much for your help!

Awesome!!! Thank you very much for your help, i really appreciate it!