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):