Help with excel

How can i tell excel to take the last value in a column before the “0” that completes the column