2 Replies Latest reply: Apr 19, 2016 10:08 PM by alvinford ford RSS

    How to fill the blanks with the previous Value

    alvinford ford

      Hi All,

       

      I have my data as below, need to fill the gaps using the previous value. Used the following formula

      if(Len(Step)>0,Step,Peek(Step)) as Step2 but it is only filling the next row not all the rows. Request your help to achieve this.

       

      Need to achieve this using script.

       

      Please refer the attachment for data.

       

      Thank You in Advance...

       

       

        

      OutSoldB224395
      PRCB224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      TransferB224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      B224395
      CPCB224395
      B224395
      B224395
      B224395