The task is to expand the two numbers in each row into continuous number intervals.
Solution: Use SPL XLL and enter the provided code to split the numbers and form a continuous sequence.
The code loops through each row, splits the numbers using the minus sign, converts them to an integer sequence, and then expands each row into multiple rows based on the number of members in the sequence.
Download esProc Desktop for free to reshape your data with SPL XLL.