Normalization of data

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

I looked at your temp.xlsx data. What is supposed to happen when the Product values do NOT start(or end) in the same month?

From a database stand point, doing this is hazardous to the integrity of the info. I.e. you are moving from real dates to numbered months. You lose information when this happens.

you could use some conditional formatting to help identify the areas:

eg in cell C3:

format>conditional formatting

condition1: 'Formula Is': =AND(C3>0,SUM($C$3:C2)=0)
condition2: 'Formula Is': =AND(C3>0,SUM(C4:$C$23)=0)

set the format to be a different colour font or something similar. Then to get this everywhere use the format painter.