How can we delete a row if there is no data in the immediate next row?

How can we automatically delete a row if there is no data in the immediate next row?

However, if there is any data in the immediate row, the first row should remain as it is.

For eg:- In the attached file, there is no data in row 3, I want to get the data in row 2 to be deleted automatically, but not if there has been data in row 3.

Ep test-2.xlsx

Dynamic Processing

Accepted answers

nagakavyasri

@Kartik21 In short, do you want the last row to be deleted? If so, try this:

Screenshot 2024-10-29 122740.png

10-29-24.1.yxmd

All comments

atcodedog05

Hi @Kartik21,

I think you have attached the wrong excel file. Can you please check?

Kartik21

@atcodedog05 - The file is absolutely correct.

OTrieger

@Kartik21
Add a RecordID tool and then filter all the empty rows. Add a Formula tool that will be RecordID-1 then Join the data and in the Left side you will have the data and in the J you will have the row that were removed.

atcodedog05

Hi @Kartik21

I can see only one row

Screenshot 2024-10-29 201516.png

nagakavyasri

@Kartik21 In short, do you want the last row to be deleted? If so, try this:

Screenshot 2024-10-29 122740.png

10-29-24.1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703