Assign a district to choose from drop down list for all bellow until you find another yellow row

I want to read the excel file and then type all the names and area in the website and also choose from the dropdown list the District , The district is written in a yellow for all the bellow .

The question is how can I tell the bot that the yellow row is a district you have to choose from drop down list for all bellow until you find another yellow row

This is the excel file


and this is the website I have to fill the information in

District

@Rawan_Ghurab

If the cells of districts are merged always then when you read the excel as datatable…the data for that particular row will exists only in fiets column the second column will be wmpty…in your for loop you can identify the second row empty and change the district

Hope this helps

Cheers

Thank you so much for your quick response ,

I understood the logic you are trying to explain but I could not know how to develop it

I will be thankful if you helped me on this

@Rawan_Ghurab

This is how it looks

IsNothing(CurrentRow("Area Of Practice")) OrElse String.IsNullOrEmpty(CurrentRow("Area Of Practice").ToString.Trim)

cheers