14.8 Insert blank row when meeting with data change

 

Here below is a data table:

imagepng

We want to insert one blank row when the values in two adjacent rows change, the result is as follows:

imagepng

Script:

=spl("=?1.conj().group@o(~).(~|[null]).conj().new(~:_1)",A1:A9)

esProc Desktop and Excel Processing
14.7 Insert row after specific row
14.9 Expand into multiple columns horizontally