Removing empty rows from a set of data - Need some help please!

Hi guys, I need some help removing empty rows from my set of data.

I have a big set of data that I'm copying and pasting into excel. When I paste it there are 2 empty rows between each line of data. I want to remove these empty rows, without affecting the data. I tried 'Go to special...' and deleting all empty cells and stuff but I couldn't get it to work. The problem is that there are blank cells in some of the rows that I want to keep. When I try to remove the blank rows, I also end up removing rows of data that I want to keep.

I've made an example for you to try and explain it better - attached.

If you could help me remove all of the rows that are completely empty, but leave any row that has any data in it (at any point), that would be awesome!

Thanks in advance, Dave

col A is not empty for any row that we want to keep. it's of course empty for all of the rows that I want to delete.

Thank you very much. Works perfectly on the test document, can't check it on the real thing right now, but I won't bother bumping the thread again unless I have any problems.

Thanks again.