Hello friends I am back again with a new excel trick for you to learn. Today I am trying to explain a very simple way to add a blank row after each record in your data. This trick is very special because without VBA it is the only method to insert a blank row to your data except doing it manually.
Let me first tell you a little bit about the objective that I am planning to achieve. See the image below:
I want to insert a blank row after each record in my data. So there should be blank row between "Chris Smalling" & "Fabio" similarly between "Jonny" & "Nemanja". Now the challenge is to do it without using VBA codes. So here you go with the solution.
Enter a series of numbers in the column next to your data. You can also use "Fill Handle" to put the series of numbers if your data is large, this is an efficient way of putting numbers.
Once you have numbers next to your data select the series and copy it. Go to the last number in the series and below it paste the full series again.
Now select your complete data along with the series entered. Here the series has been entered in column 2 and now sort it in ascending order with the column containing your number series.
Now if you see your original data has got a blank row after each record. This is what we were trying to achieve with this trick. I know this can be done with a very simple VBA code, for my super efficient VBA loving friends I am posting the code in comments below.
I hope we you all have gained something out of this post. Your suggestions and feedback are most welcome. Till then "HAPPY LEARNING"