[SOLVED] How to copy a column data in another column, ignoring the blanks

Hello,

Let me get right into my question:

In column A I have a list of datas, but those datas are not corectly sorted, it looks like :

875
47

541


9855

44
2




845


54

The datas are separated by blank cases, the space between 2 data is totally random, sometimes 2 datas will be right next to each other, sometimes i will have 5 empty cases between 2 datas (verticaly)

In the column B I want to keep this exact same datas but without the empty spaces
so my column B would look like :

875
47
541
9855
44
2
845
54

How can I do that ?

Thank you very much for your help.
Max