#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:…


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Problem description & analysis:

Here below is a data table:

source table

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

expected results

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: cases: Desktop and Excel Data Processing Cases

YouTube FREE courses: SPL Programming


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing


Print Share Comment Cite Upload Translate Updates
APA

Judith-Excel-Sharing | Sciencx (2025-02-17T03:11:01+00:00) #145 — Insert Blank Row when Meeting with Data Change. Retrieved from https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/

MLA
" » #145 — Insert Blank Row when Meeting with Data Change." Judith-Excel-Sharing | Sciencx - Monday February 17, 2025, https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/
HARVARD
Judith-Excel-Sharing | Sciencx Monday February 17, 2025 » #145 — Insert Blank Row when Meeting with Data Change., viewed ,<https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/>
VANCOUVER
Judith-Excel-Sharing | Sciencx - » #145 — Insert Blank Row when Meeting with Data Change. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/
CHICAGO
" » #145 — Insert Blank Row when Meeting with Data Change." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/
IEEE
" » #145 — Insert Blank Row when Meeting with Data Change." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/. [Accessed: ]
rf:citation
» #145 — Insert Blank Row when Meeting with Data Change | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2025/02/17/145-insert-blank-row-when-meeting-with-data-change/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts