If rows are empty, double click short cut on extend formula hand will not work. So what can you do? How can you resolve it?
Copy cells from left side column into the one that you want to update. There is likely that data exists in columns somewhere. Once data is there, you can use double click shortcut to extend the formula to all rows that you just copied.