Checking empty rows/cells in rows: if empty - duplicate data cell above

Hello!

I am building a robot which needs to read info from a website and put the info in a structured way into an excel sheet.

The table of information on the website is not very structured and therefore i need to scrape one column at a time. Some columns in the table can contain multiple rows, and in this case i need the robot to check if there are any empty cells, and if there is: the value from that particular column’s row above needs to be duplicated. To show an example (the cells are not actually yellow):

image

1 Like

you could try to loop in the rows . If it has a content then save it to a variable else write the value of the variable to the blank cell