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
esProc Desktop and Excel Processing
14.5 Make up missing parts to make data continuous
14.7 Insert row after specific row
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/