Transpose with an addition of row inserting

hi All,

i am humbly asking a help from experts and gurus in here about a problem im facing. I know theres been a lot of "transpose" thread out there, but due to my lack knowledge for macros and VBs, i am unable to custom nor change the solutions according to my need.

It seem to be an easy problem to be fixed with a bit copy&paste, but i am currently dealing with a huge number of datas.
A quick note, the series amount of batch&quantity in one "product" row will be expanded to a lot more. But still, i am looking to find a way so the "product" part can be pair out with each batch&quantity series from the same row.

well without further ado, here we go

thanx All!!