2 time interval data into another

Copper Contributor

Hi guys,


so the picture below shows the data I'm analysing just my issue is the Nour level 5-10 data on the right is timers from 15 minute increments where as the ones on the left are 5 minute increments and having difficulty or well very time consuming to separate it out so when I graph it I can line it up against one another to trend.

Ive tried text to column and filtering but I don't get the results I want unfortunately so don't know what else to try outside of the time consuming of shift down cells




1 Reply



If I have understood correctly, you want to insert 2 empty lines for the rows from 16035 for columns H - L in order to synchronise the times in column A. That would be easy. But I am not sure if I have understood it correctly.