14.6 Add several blank rows every N rows
There is a data table that stores the detailed data of student examination room and seat number, and part of the data is as follows:
Now we want to add two blank rows after every 13 rows. The result is as follows:
Script:
A | |
---|---|
1 | =E(‘A1:D152’) |
2 | =row=A1.create().insert(0) |
3 | =A1.group((#-1)\13).(~|row|row).conj() |
A2: Copy the data structure of A1, insert one blank row, and assign this row to the variable row
A3: Take every 13 students into a group, add two blank rows after each group, and then concatenate each group into a data set
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658631595152
https://c.scudata.com/article/1658708353107
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/