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

[Kartik21]

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.

[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

[nagakavyasri]

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