copy cells ignoring blanks

Hi Guys,

I need to copy the contents of Column A into another sheet.

Column A has lots of blank cells as well as cells containing the work 'ENTRY'. These cells should NOT be copied across.

So the idea is to take Column A and turn it into a list (with no blank cells) on another sheet.

Any ideas?

My solution:
Make copy of column A then:
1. Press ctrl + H and replace cells with Entry into (empty)
2. Select column again and press F5 => special => empty and delete (move to up)
And You have what You wanted