Dear Sir /Madam,
The sheet 1 (input file) is the given file. i need output like in the Sheet2(required output sheet). For easy understanding i had given colors for your kind reference. from that lease remove the cell apsim version cell and the headings from the second set onwards.

in simple words I need output like in the second sheet. (hope I m not confusing)please do help me...

please oblige and do the needful... PLEASE FIND THE ATTACHMENT...

Thanks & Regards,
Dharani.
full files.xls