3 Replies Latest reply on Aug 3, 2018 1:26 AM by Jasper Li

    About Ordering Sequence with Condition

    Jasper Li

      Hello Everyone! I want to ask a question about ordering a sequence with condition.

      For example, I have a table as below:

      Sequence
      Values
      1B
      2A1
      3A2
      4B
      5B
      6A2
      7A1

       

      Is there any method to get a order sequence excluding B, like below?

      Sequence
      Values
      New Sequence
      1B0
      2A11
      3A22
      4B0
      5B0
      6A23
      7A14

       

      Thank you for everyone!