Looking at all these imaginative solutions gave me some insights, then my challenge workflow has been upgraded from two to four different optional approaches. There’re tons of fun in this challenge, we could keep ideating approaches forever.
Tying to @Thyme 's, my four solutions:
- Moving Aggregation cumulative computation.
- Missing Value downwards (previous value) and upwards (next value) infill.
- Conditional Loop End, computing stripped starting and trailing noise lengths.
- String concatenate and Regex code to strip starting and ending zero values.
Last one inspired from @MEPivnenko 's concatenate (I didn’t check into the code avoiding spoiler); then deepening into ‘non-greedy’ Regex code with some help from forum and @ipazin solution.
BR