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(~)...
esproc-desktop.hashnode.dev1 min read
esProc
📌 Tired of Excel’s limitations? SPL XLL makes complex tasks effortless! Check more hacks with the communities!
💭Discord: discord.gg/sxd59A8F2W 💭Reddit:reddit.com/r/esProc_Desktop