I had a few rows of data and I had to insert multiple empty rows (5) in between each row. Initially I wrote a simple VBA macro to do it, but later a colleague showed me a much simple way to doing the same thing using Excel’s “Sort” function. Here’s how:
Step 1: Insert the data in continuous rows.
Hope this information helped