Hey guys, i was wondering if anyone could help point me in the right direction.

lets say i have an array like this:
0
0
1
5
7
0
0
7
7
7
0
0

i dont want the 0's before the first number(>0) and after the last number(>0), so it should return .
1
5
7
0
0
7
7
7

any guidence would be appriciated im trying to do this kind of thign with alot of data. and multiple columns. Thank you

please see attachment for what the data will look like and what i want the result to be
temp.xlsx