Hello @Aarthy1
I hope I am understanding your question correctly.
The Read Range activity can read your excel sheet to a datatable (create a new datatable variable dtInput).
Create a new output datatable variable dtOutput.
From there you can use the For Each Row in Data Table to add each row to dtOutput if it is not empty (if CurrentRow.ToString <> “”)
Finally you can write the datatable to your desired excel sheet using the Write Datatable to Excel activity.