Forum Discussion

ColinCowan's avatar
ColinCowan
Helper I
3 years ago
Solved

Identify Number and Fill Down

Hi, need help with the below, I have tried although I am unabel to solve. My aim is to identify each number above the date and time, then fill the identifed number down against the date and time inc...
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    ColinCowan 

    Hi,

    Change column data type to Whole Number.

    Then replace error as null

     

     

     

    Then fill down.

    Thank you.

     

Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

ColinCowan 

Hi,

Change column data type to Whole Number.

Then replace error as null

 

 

 

Then fill down.

Thank you.

 

  • ColinCowan's avatar
    ColinCowan
    Helper I
    3 years ago

    Hi

    First step

    2nd Step Whole Number returns