I'm attempting to parse data based on a count variable on each line for machine cycle times. In this situation, one data entry doesn't necessarily attribute to one cycle. Rather, a data entry can contain anywhere from about 1 to 4 cycles where the time between datestamps is averaged out over the number of cycles that entry contained. I would like each cycle to be its own line with a cycle time value so I can create an accurate time series plot to analyze trends. Would there be a way to loop each entry to create another under it until n-1 = gap?
-----EXAMPLE DATA-----
Datestamp CycleTime Gap
1/9/2017 2:00:13 PM 5.2 2
1/9/2017 2:00:29 PM 5.0 0
1/9/2017 2:00:34 PM 5.4 1
-----DESIRED OUTPUT-----
Datestamp CycleTime
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:29 PM 5.0
1/9/2017 2:00:34 PM 5.4
1/9/2017 2:00:34 PM 5.4
