Deleting zeros from a column

[JackieChrist]

Hello!

I have a column of numbers in order from lowest to highest with zeroes interspersed. Example: 1 0 0 4 0 6 7 0 0 (if this were a column rather than a row), and I am wondering if there's a way to get the column to look like this: 1 4 6 7 (or creating a new column that looks like that)

[Pepe Le Mokko]

Use the filter to remove the zeroes

[JackieChrist]

Sorry...I don't know what a filter is...very new to excel. Any explanation?