Merge Columns

[sharma4845]

sir,
i have a worksheet in that, i need following data..
Sheet (Order Form) in that i have enter item qty in different colors Column wise

A12 E12 : O12 Q12 R12 S12
1003 2 5 10 11
1005 0 11 15
1006 1 10 5

merge all above column in below condition..

merge data of column A + E:O (if having any value / skeep blank value (it must be numeric) + Q + R + S if column P is "Y".

final get data like below in FCSV file..

A B
1003 SNW Qty of E
1003 SNW Qty of F
1003 SNW Qty of G cont. end of O12.
if colum P is "Y" than
Q Qty of E
R Qty of E
S Qty of E

pls help..attached sheet for your ready reference.

ragds,
Ganesh Sharma