1 Reply Latest reply: Oct 1, 2013 6:36 AM by Cs Khoo RSS

    List out the value give certain range

      Hi All,

       

      Anyone can help on this? Refer to tables below.

       

      MeasurementRange1Range2Range3
      AAAA000-2006000-700080-90
      BBBB

      111-300

      8000-900060-50
      CCCC200-4004000-5000

      90-100

       

      I would like to list out all the range in row by row as per below table.

       

       

      MeasurementRange1Range2Range3
      AAAA000600080
      AAAA001600181
      AAAA002600282
      BBBB
      CCCC
      CCCC

       

      Would like to list out all the range from 000 till 200 for AAAA and others as well. Any idea?

       

      Regards,

      OrangezKhoo