1 Reply Latest reply: Aug 19, 2015 10:54 AM by Massimo Grossi RSS

    Creating a Range for a Defined list of values

    Shaun Somai

      Hi

       

      I have this  set of data

        

      Account Group1ACCTSEGVAL
      Billings - Fees1100
      Billings - Fees1101
      Billings - Fees1102
      Billings - Fees1200
      Billings - Fees1210
      Billings - Fees1220
      Billings - Fees1300
      Billings - Fees1301
      Billings - Fees1302
      Billings - Fees1303
      Billings - Fees1304
      Billings - Fees1305
      Billings - Fees1306
      Billings - Fees1307
      Billings - Fees1308
      Billings - Fees1309
      Billings - Fees1310

       

       

      Need to get it like this

         

      Account Group1StartEnd
      Billings - Fees11001102
      Billings - Fees1200
      Billings - Fees1210
      Billings - Fees1220
      Billings - Fees13001310

       

      To be done in the script

       

      Any Help Apprreciated