2 time interval data into another

[AhmetHa]

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

[#2]

@AhmetHa 

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.

=WRAPROWS(IF(TOCOL(H16037:V17244)="","",TOCOL(H16037:V17244)),5)