14.2 Generate continuous array - concatenate results into a string
The values in columns A and B are natural numbers, representing the start and end points of the array respectively:
The task is to use the values in columns A and B to generate a string composed of natural number array, and fill in the result in column C, as follows:
Enter in cell C2:
=spl("=to(?1,?2).concat@c()",A2,B2)
Then drag C2 down to every relevant row:
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658455398473
https://c.scudata.com/article/1658533791730
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/