Problem description & analysis

Below is Excel data:

If the value of column A is empty, copy the value of column C in the current row to column D of the previous row. Continue such operation in a loop, and then delete the currently empty rows. Below is the expected result:

Solution & explanation

Use SPL XLL plug-in of Excel

Write the formula in a blank cell:

=spl("=?.run(if(~(1)==null,~[-1](4)=~(3))).select(~(1))",A1:D6)

As shown:

Explanation:

Handle each row in a loop. For the current row, if the first member is null, the value of the third member of the current row is assigned to the fourth member of the previous row and then filter away the row where the first member is null.

Q & A Collection

https://stackoverflow.com/questions/63790459/check-cut-and-paste-delete-row-move