...
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 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL