The other day, I was preparing a dashboard and I came across this problem:
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: