Looking at excel file, there appears to be problem with the stock reference data. I would imagine this will be mixed up with other data if a standard excel import is attempted as it does not fit a unified format.
I would wait and see if others have any ideas or suggestions but my first thought would be converting to a standard csv text file (excel can do this).and procesing with a script. I had to do this with a odd data format of separate field on each text line and records defined by a blank line. The exact format of this script would need to be custom made but BD is quite versatile in these situations. The only down side is speed of processing if more then a few hundred records.
BD does have built in parsing but I found making my own script more flexiable.
Not a five minute task but would play with idea if no other solutions found.
I would change the excel file. Can't you simply create an additional column "StockRef" with the repeated values for each row? Then delete the highlighted rows with StockRef and import. Each row / record will have its own StockRef value. Depending on how many records are involved, macros could be created to accomplish the above very quickly. Just my thoughts.
MacHeuS sure is quick off the block - great work. This is similar to what I had in mind but would have taken me a few days to fine tune. The only addition I might make would be to open and read text file with BD script actions but with a small amount of data, copy and and paste would appear quite practical.
This one of the reasons I like BD - it has accessable to tools to achieve almost any task.