In Excel, If email column has null for the first row then it should pick the second row

Help Studio
1

So, I have used read range activity, In that i have taken the sheet name and cell, And variable is Contact_DT.
I want to check if A5 cell is blank then i need to pick the A6 row

Kindly help

2

Hi @Vardhan1 ,

Have you tried the filter data table activity?, it can filter out the blanks by taking your desired column name as reference.

Regards,

1 Like