I am not sure if all your details are evenly spaced but if they are you
could record a macro, in relative mode.
select your cell where you want the macro to start,
go to record maro,
select a name,
a square box will show up, click on the box and it should appear
depressed, you are now in relative mode.delete the areas you want and
select the cell in the next starting position.
stop macro
test it out a couple of times to see if it does what you want.
I will get you a loop in the next few minutes

It looks like you can delete some columns before you record this macro