Eliminating blank cell from a list

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.

Thanks for the response. Actually the set of numbers were derived from calculation by excel formula that linked to each cell. In this case, the list of numbers generated are 1 0 12 25 0 55 0 0 6 7 (zero only. not a blank cell).

The reason I mention blank cell is because I have found an answer to similar a scenario at this link http://www.cpearson.com/excel/noblanks.htm

In that case, it refers to list of texts while my problem is referring to set of numbers. Adding to that, I really don't know how to use the code given.

Really appreciate assistance from you guys.

Instead of checking for vbNullString, you check for 0. What about just sorting the data though?

Thanks for the advice.