Check row is empty or not in excel and update value in another sheet of excel

[lakshmi.mp]

Hi All,

Book1 test.xlsx (9.2 KB)
This is my sample excel, if row B is blank it should fetch the row C and write in another sheet say sheet2 excel file.

Need to consider the blanks and update the Column order in another excel.
Sample file has been attached, please look on it.
How to do this, please help me.

Thanks,
Lakshmi

[Mr.H]

Which is the output you want ?

Pls take screenshot or send the sample file.

[lakshmi.mp]

@Mr.H

required output.
Output need to be stored in this sheet.

Sample file
Book1 test.xlsx (9.2 KB)
Please look on it.
Regards,
Lakshmi

[Gokul001 (Gokul Balaji)]

Hi @lakshmi.mp

1. Read the excel file using Read Range activity Store in Dt Variable
2. For each row in DataTable activity
3. If Activity

String.IsNullOrEmpty(CurrentRow("Number").Tostring)

Then Part
You can process your needing here!

Else Part
We have a value in the row in the Number column

Regards
Gokul

[Mr.H]

Pls check sample
File.zip (68.9 KB)

[lakshmi.mp]

@Mr.H and @Gokul001 ,

Thanks a lot for helping and providing solution. Able to fetch the data.
Thank you.

Regards,
Lakshmi