There is a column of serial numbers (No), as shown in the figure below:

Now we want to use the two numbers in each row to expand into continuous number intervals, like this:

Script:

=spl("=E(?1).news((a=No.split(""-"").(int(~)),to(a(1),a(2)));~:No)",A1:A3)

Loop through each row, and split No with the minus sign, and then convert the split numbers to an integer sequence and assign it to the variable a, and finally form a continuous sequence of numbers with a(1) and a(2). The function news means expanding each row into multiple rows according to the number of members of the number sequence, and the numeric member is the value of No in the new row. 

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658455072793
https://c.scudata.com/article/1658533755563