Finding first non-zero value in a column and then return all values (non-zero&zero)

Hi,

I have a problem which I do not know how to solve. I am trying to find a formula which returns the first non-zero value in a column as well as all other values in that column (both non-zero and zero values). The point is to skip all the zero values in the start of the column, and then return all values as they are after skipping the first zero values (if there are any). I would like to extract these values to a new column with the desired values to start on the top. As of now I have just seen formulas returning first non-zero value but then stops. I have also managed to return all non-zero values.. But this does not solve my problem...

Thank you in advance!

Thank you for your fast reply! I will attach my worksheet.

returning data.xlsx

Thank you very much Tom! The code worked perfectly. But I have one more question. Can you help med design the exact similar code only substituting the zero´s with blank cells? Thank you! Attached you will find the worksheet showing how I want it to look like.

Marius

returning data.xlsx

Thanks Tom! Appreciate it!