Forum Discussion
2 time interval data into another
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 in...
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)