![[The AI Show Episode 142]: ChatGPT’s New Image Generator, Studio Ghibli Craze and Backlash, Gemini 2.5, OpenAI Academy, 4o Updates, Vibe Marketing & xAI Acquires X](https://www.marketingaiinstitute.com/hubfs/ep%20142%20cover.png)
![[FREE EBOOKS] The Kubernetes Bible, The Ultimate Linux Shell Scripting Guide & Four More Best Selling Titles](https://www.javacodegeeks.com/wp-content/uploads/2012/12/jcg-logo.jpg){kind=logo}
![From drop-out to software architect with Jason Lengstorf [Podcast #167]](https://cdn.hashnode.com/res/hashnode/image/upload/v1743796461357/f3d19cd7-e6f5-4d7c-8bfc-eb974bc8da68.png?#)
.png?#)
.jpg?#)
_Christophe_Coat_Alamy.jpg?#)
![Rapidus in Talks With Apple as It Accelerates Toward 2nm Chip Production [Report]](https://www.iclarified.com/images/news/96937/96937/96937-640.jpg)
#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!!!
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!!!
