Table and Dropdown Insert to DB issue

I can get 1 row to insert but not all the rows in the table. It should loop through each one and avoid the rows where column 1 is blank.

if I put a value in each row in column 4 then it will insert all 9 rows that are completely field out. before I just had a value in one row in column 4. well thats one part. Now that part is figured out.

I need to set it up to where if column 2 values are = “no” then column 4 values can’t be blank for that row
but if column 2 values are =“yes” then column 4 values can be blank. any ideas.

Please edit your post to have a triple-backquote (these: ```) line above your code and another below your code, so it’ll format with readable indendation.

I belive I have it where it is readable