<h2 id="heading-problem-description-amp-analysis">Problem description &amp; analysis:</h2>
Here below is a data table:
<img src="https://miro.medium.com/v2/resize:fit:444/0*46q8nBuV0NDbQfmq.png" alt />
Task: We want to insert one blank row when the values in two adjacent rows change, the result is as follows:
<img src="https://miro.medium.com/v2/resize:fit:368/0*ZC9SR4Ocg-zbZV4a.png" alt />
<h2 id="heading-solution">Solution:</h2>
Use SPL XLL and enter the following code:
<pre><code class="lang-plaintext">=spl("=?1.conj().group@o(~).(~|[null]).conj().new(~:_1)",A1:A9)
</code></pre>
<hr />
Download esProc Desktop for FREE and boost your working speed with SPL XLL!!! 🚀✨⬇️
SPL download address: <a target="_blank" href="https://www.esproc.com/download-desktop/">esProc Desktop FREE Download</a>
Plugin Installation Method: <a target="_blank" href="https://c.scudata.com/article/1652061135502">SPL XLL Installation and Configuration</a>
References to other rich Excel operation cases: <a target="_blank" href="https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html">Desktop and Excel Data Processing Cases</a>
YouTube FREE courses: <a target="_blank" href="https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso">SPL Programming</a>

## **Problem description & analysis:**

Here below is a data table:

![](https://miro.medium.com/v2/resize:fit:444/0*46q8nBuV0NDbQfmq.png align="left")

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

![](https://miro.medium.com/v2/resize:fit:368/0*ZC9SR4Ocg-zbZV4a.png align="left")

## **Solution:**

Use **SPL XLL** and enter the following code:

```plaintext
=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](https://www.esproc.com/download-desktop/)

Plugin Installation Method: [SPL XLL Installation and Configuration](https://c.scudata.com/article/1652061135502)

References to other rich Excel operation cases: [Desktop and Excel Data Processing Cases](https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html)

YouTube FREE courses: [SPL Programming](https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso)

#145 — Insert Blank Row when Meeting with Data Change

Problem description & analysis:

Solution: