Bad design.
Just break your table into two tables a master and a detail table, and the (pr_nam1,batch1,exp_dt1,drg_mfg1,qty1,mrp1,g_amt1,disc1,net_amt1) values can have a foreign key to the master (you can add a LINE_NO instead of the 1,2... etc in the names).
This way you are not limited to 9 items and the design is much simpler and more performant.
EDIT:
Master table
-------------
ID,
Bill_no,
B_date,
Pa_name,
P_addr,
ph_no
Details table
-------------
ID,
LINE_NO,
Master_ID,
pr_nam,
batch,
exp_dt,
drg_mfg,
qty
...
Foreign KEY reference : detailstable.Master_ID -> mastertable.ID