14.8 Insert blank row when meeting with data change
Here below is a data table:
We want to insert one blank row when the values in two adjacent rows change, the result is as follows:
Script:
=spl("=?1.conj().group@o(~).(~|[null]).conj().new(~:_1)",A1:A9)
esProc Desktop and Excel Processing
14.7 Insert row after specific row
14.9 Expand into multiple columns horizontally
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/