#145 — Insert Blank Row when Meeting with Data Change

Problem description & analysis:

Here below is a data table:

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

Solution:

Use SPL XLL and enter the following code:

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

---

Download esProc Desktop for FREE and boost your working speed with SPL XLL!!! 🚀✨⬇️

SPL download address: esProc Desktop FREE Download

Plugin Installation Method: SPL XLL Installation and Configuration

References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

YouTube FREE courses: SPL Programming