Selecting none blank rows in a column

Have this in a column:-

1


123

654345
1



22

33
Want this in a separate worksheet:-

1
123
654345
1
22
33

How can I get excel to automatically 'transfer' just values (and no blank rows) from one column into another on a separate sheet?