Following is the output from newly edited script.
Let me know if you prefer to take it.
PartNumber,ProductNumber,ProductDetails
A001,A001-500g,"L; ; Cone cap/Glass bottle; ; Not hazmat; Not DG"
A001,A001-100g,"L; ; Cone cap/Glass bottle; ; Not hazmat; Not DG"
A001,A001-1kg,"L; ; Cone cap/Glass bottle; ; Not hazmat; Not DG"
A001,A001-25g,"L; ; Cone cap/Glass bottle; ; Not hazmat; Not DG"
A001,J92163-100g,"L; ; Cone cap/Glass bottle; ; ;"
A001,J92163-25g,"L; ; Cone cap/Glass bottle; ; ;"
A001,J92163-5g,"L; ; Cone cap/Glass bottle; ; ;"
A001,A001-5g,"L; ; Cone cap/Glass bottle; ; Not hazmat; Not DG"
A001,J92163-1kg,"L; ; Cone cap/Glass bottle; ; ;"
A001,J92163-500g,"L; ; Cone cap/Glass bottle; ; ;"
A002,A002-25g,"S; ; Poly bottle; ; Not hazmat; Not DG"
A002,A002-500g,"S; ; Poly bottle; ; Not hazmat; Not DG"
A002,A002-100g,"S; ; Poly bottle; ; Not hazmat; Not DG"
A002,A002-1kg,"S; ; Poly bottle; ; Not hazmat; Not DG"
A002,A002-5g,"S; ; Poly bottle; ; Not hazmat; Not DG"
A002,J92426-25g,"S; ; Poly bottle; ; ;"
A002,J92426-100g,"S; ; Poly bottle; ; ;"
A002,J92426-5g,"S; ; Poly bottle; ; ;"
A002,J92426-1kg,"S; ; Poly bottle; ; ;"
A002,J92426-500g,"S; ; Poly bottle; ; ;"
A003,A003-100g,"S; ; Glass bottle; ; Not hazmat; Not DG"
A003,A003-1kg,"S; ; Glass bottle; ; Not hazmat; Not DG"
A003,A003-25g,"S; ; Glass bottle; ; Not hazmat; Not DG"
A003,A003-500g,"S; ; Glass bottle; ; ;"
A003,A003-1g,"S; ; Glass bottle; ; Not hazmat; Not DG"
A003,A003-10g,"S; ; Glass bottle; ; ;"