Reorganizing Data

Hey guys,

I have been running into a few issues about the way my excel is organized and was wondering if someone can help out.

The issue is that I have a list of many products that I need to import a certain way into a program and for that I need to split them to individual lines from the one column they are associated now.

Each product has information that will not change and stay the same except for three details (code, sell price and buying price) associated to their size.

Here is an example of how I have the data
Example 1.PNG


And here is how I would like to have it using a script

example2.PNG


As you can see the main product needs to be split in 5 containing the unique ID then each one associated with their "size" and prices per line.

Please let me know if you have a question,

Thanks in advance

TESTCSV.csvPrices.csv