Delete rows in sheet by looping backwards !

Hi

I have imported a textfile to my sheet thats could looks like this

textfile:
aaaa 11111 25622
bbbb 22222 254155
cccc 33333 356998
dddd 44444 532256


aaaa 11111 522546
bbbb 22222 154123
cccc 33333 44512
dddd 55555 11255
(2)
aaaa 11111 5245454
bbbb 22245 556t565
cccc 33333 4454545
dddd 55555 4545454(1)

Is it possible to loop from last row (1) to first empty row (2) and delete that row plus all the rows above
so it looks like this ?

textfile
aaaa 11111 5245454
bbbb 22245 556t565
cccc 33333 4454545
dddd 55555 4545454

Best regards

Petter

Bok1.xlsx