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


esProc Desktop and Excel Processing
14.5 Make up missing parts to make data continuous
14.7 Insert row after specific row