Forum Discussion

AhmetHa's avatar
AhmetHa
Copper Contributor
May 09, 2024

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 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

 

 

BI & Data Analysis
Charting
Excel on Mac
training
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    May 10, 2024

    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)

     

     

Resources