Increment count skips, when copying forumla

Hi
I hope someone can answer this question.
I have a spreadsheet that I input data in one sheet, and process it for csv export in the other.
The problem is we need to arrange the data in such a way that it can be read by csv
Now the csv must read each quantity and its price in a separate line, for this data to be uploaded to a website later.
now, I have a way to organize the data from the client file such that it list each quantity and its prices in a different line
I used excel commands to organize the data
the problem is now each product item in the client sheet will be split into 9 rows and when I copy the formula to the next cells the next cells will be incremented by 9
I don’t want this to happen .
My product in this case is ID – DI701, 9 lines later I want the next product to be DI702, but instead its DI709.

Any ideas what I am doing wrong? I am attaching the file