There are a couple approaches you can take.
It might be best to manipulate the excel with a datatable (assuming “Pending” is at the bottom of the datatable variable), so if you initially use Read Range, you can do it like this:
Filter to Pending rows as an Array of DataRows
Inside a generic For each (DataRow TypeArgument), Use Add Data Row using ArrayRow property like rowVar.ItemArray
inside the same For each, use Delete Data Row using Row property
Clear sheet, then Write Range to same sheet (or Write to a new sheet or file)
So, essentially, you are adding the row to the bottom of the table, then deleting the row from the top.
Additionaly, another approach would be to find the index of the Pending row, which you can do in the same way you filtered the other rows but just look for “Pending” in first column.
To find index you can do this:
dt1.Rows.IndexOf(arrayVar(0)) // use (0) because it is an array of rows
Then you can use that index in the Write Range, et cetera
I hope this helps you in the right direction.