Empty Cells

Hello Lads
I am using for each to join data from 8 columns into one column but I am facing a problem that when the whole cells are empty in the next step the bot is writing the next data in the previous cell and continue and this leads to misalignment with the order
Please could u give me a hand

Check if the cell value is empty or like this string.isnullofempty(cell_value) this will return TRUE if cell is empty else it will return false.

1 Like

Capture1

but still there is a misalignment

Only Col5 value will be empty or any other columns also empty

1 Like

any other but i gave you an example

Then check all the columns if all columns contains value then add.

1 Like

ok and if not i want to leave it as a blank and continue from the next cell

Yes @marwan992

1 Like

still same problem @kalyanDev

33

Check all cells in one if a condition like this String.isnullofempty(column_value) AND String.isnullofempty(column_value) pleace and place all your columns

still facing the same issue , this is my workflow please have a look

Excel_Filter.xaml (61.8 KB) this is

@marwan992

Use Copy Paste Range activity

1 Like

without add data row ?