I am currently trying to input updated supplier data into a website. Currently what I am trying to do is if the address section is blank for a supplier, move on to the next item, otherwise fill out the address in the excel file and delete the secondary address line that is right below it.
I am trying to do this in an if loop shown in the image below: