How to Insert an Empty Row Wherever the Excel Cell Value Is Changed

We have an Excel file book1.xlsxcontaining data as follows:

Now we need to insert an empty row each time the cell value is different. The expected table is as follows:

It is convenient to do this in esProc.
You can download esProc installation package and a freeDSKlicense file HERE.

1. Write script p1.dfxin esProc:

A1 Read in data of book1.xlsx; @w option enables reading data as a sequence of sequences.

A2 Create a new group whenever the cell value changes and insert an empty row at the end of the last group, and then concatenate all groups.

A3 Export A2’s result to book2.xlsx; @w option enables outputting data as a sequence of sequences.

2. Execute the script to get the desired table in book2.xlsx.




Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Crossing the Community Bridge

Clean Code: I should’ve done that

Imagezerow is your #1 alternative for low code background removal software.

Phala Crowdloan Upgrade | Double Rewards Coming!

Creating the IAM In The AWS

Meet Tatum at 2022 ETHNewYork and join the hackathon!

Building a strong development team

How to Make Android Applications?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
chuxin huo

chuxin huo


More from Medium

twothousand&twenty.two questions


Random Thoughts on Obi-Wan Kenobi from Jacob Schoeneberger Part 4

Jacob Schoeneberger

Ancillary 9