![[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)
#144 — Insert Row after Specific Row
Problem description & analysis: Here below is a data table: Task: Insert one row after the number 100, and fill in a001, a002, … in turn, like this: Solution: Use SPL XLL and enter the following code: =spl("=E@b(?1).group@i(~[-1].#1==100).(~|new(string(#,""a000""):_1)).conj()",A1:A9) Code explanation: Group the data. When the value in column A of the previous row is 100, create a new group. Loop through each group, insert a record at the end of the group, whose value of the first column is the current group number #, formatted with “a000”. Download esProc Desktop for FREE and simplify your workflow with SPL XLL!!!
Problem description & analysis:
Here below is a data table:
Task: Insert one row after the number 100, and fill in a001, a002, … in turn, like this:
Solution:
Use SPL XLL and enter the following code:
=spl("=E@b(?1).group@i(~[-1].#1==100).(~|new(string(#,""a000""):_1)).conj()",A1:A9)
Code explanation: Group the data. When the value in column A of the previous row is 100, create a new group.
Loop through each group, insert a record at the end of the group, whose value of the first column is the current group number #, formatted with “a000”.
Download esProc Desktop for FREE and simplify your workflow with SPL XLL!!!
