I hope you are all healthy.
I would like to filter a column in my excel sheet for empty fields. In those empty fields I need to add some data (in this case just the number “1”). How is it possible to do that? Would the Filter Wizard change the Excel as well?
Sometimes the column has more or less rows that are empty and that’s why I need the process to be dynamic.
I think you can understand it better if you see the screenshot:
Column G is filtered for the rows that are empty (I did it so that you can understand it better. Actually the whole excel sheet is not filtered yet. I want UiPath to do it) and now I want to put “1” into the whole column G (except G1 )
I hope you can help me out