Hi everybody. I'm new here.

I would like to seek help and guidance from members of this forum. Actually, I am working on an excel project whereby I have a list of numbers e.g :

1 0 12 25 0 55 0 0 6 7

I need excel to auto re-arrange the numbers to exclude the number 0 (zero/ blank cell) so that the result will looks like this :

1 12 25 55 6 7

May I know what is the formula/function should I use to get this result?

Appreciate members here to help me.