I pasted your table into an Excel sheet and ran mokhtar's code from msg#5. It worked well, but didn't try to delete any columns.
I ran SamT's codes. They both worked as far as deleting rows was concerned (you should use the exact match version but it probably doesn't matter which you choose), but when it tries to delete columns, you have to tweak the code to say which columns you want deleted (information which you did not supply) thus:
Columns("D").Delete
Columns("B").Delete
substituting the column you want deleted (remember to delete from the right as SamT says.