20 Replies Latest reply: Aug 11, 2016 5:51 PM by Sunny Talwar RSS

    Get range of values from sequence

    Mark Graham

      Hi all,

       

      I have following data:

      Name, ID

      A,1

      A,2

      A,3

      A,4

      A,5

      B,6

      B,7

      B,8

      B,9

      A,98

      A,99

      B,101

      B,121

       

      I want to make it as a range:

      O/P:

      Name  Start  End

      A            1     5

      B            6     9

      A            98   99

      B            101  121

       

       

       

      Any help is highly appreciated