List out the value give certain range

[#1]

Hi All,

Anyone can help on this? Refer to tables below.

Measurement	Range1	Range2	Range3
AAAA	000-200	6000-7000	80-90
BBBB	111-300	8000-9000	60-50
CCCC	200-400	4000-5000	90-100

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

Measurement	Range1	Range2	Range3
AAAA	000	6000	80
AAAA	001	6001	81
AAAA	002	6002	82
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

[#2]

Anyone can help the above question?