I have an excel sheet with lots of unstructured data. I want to save all the data under the keywords: art.nr, beskrivning, best.ant., á-pris etc (as in the picture). I am thinking if it is possible with the following logic: if all rows under keyword ‘beskrivning’ is not empty than extract the rows below it (and the corresponding values to its right and left). Does anyone know how to do this in uipath?
There is unstructured data before and after the screen shot I provided so hence I am trying to extract this specific part of the excel.