# 14.1 Generate continuous array

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.

esProc Desktop and Excel Processing

13.13 Interconversion of rows and columns in reverse order

14.2 Generate continuous array - concatenate results into a string

*SPL Official Website**👉* *http://www.scudata.com*

*SPL Feedback and Help**👉* *https://www.reddit.com/r/esProc_Desktop/*

*SPL Learning Material**👉* *http://c.scudata.com*

*Discord**👉* *https://discord.gg/ydhVnFH9*

*Youtube**👉* *https://www.youtube.com/@esProcDesktop*

*Linkedin Group**👉* *https://www.linkedin.com/groups/14419406/*