Condense list of data that contains some blanks to just a list of data

Hi everyone,

I appreciate you taking the time to look at this. I have a list of numbers that has blanks in it (there was a formula used to generate the data) and I want to put it into one column without blanks. So on the left is what its like now, the right is what I want it to be. There is a lot of data so I would want to select the whole column. thanks

45 45
41 41
41 41
44 44
34 34
39
39 45
45 45
45 34
42

34

42