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:

imagepng

Now we want to add two blank rows after every 13 rows. The result is as follows:

imagepng

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