Excel Masaging

hi all,
i have one excel in that some fields available so i want vender code below GMydt.xlsx (10.8 KB)
Lcode and rest manual values .i have send u sample files . i want output like sheet2.pls help if you know solution.