Last Updated on
You probably wondering how is this relevant to building niche websites. Trust me it does.
When it comes to SEO, the ability to manipulate Excel spread sheet is one of the required skills.
In this video, I am going to show you how to transfer data into empty cells in Excel.
The need for this solution arise for example, when you have a list of URLs and need to fill in the data for them (see image below). The problem is,these are non consecutive empty cells so you can not use data filter to just copy and paste the data into the empty cells. Excel will reject that action because the cells are not aligned.
I know for most of the readers you are probably scratching your head and wondering what I am talking about. Trust me, if you need to use Excel a lot, you will come across to this problem at least once in your lifetime and you would be glad to have come across to this video.