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

hello:)

More from Medium

twothousand&twenty.two questions

Buffalove

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

Jacob Schoeneberger

Ancillary 9