How To Fill Empty Cells With Value Above In Excel

If you have to deal with various software that lets you export excel file a lot, you have probably come across to a situation where you can’t manipulate the data within the file because some cells have been merged together.

merged cells in excel

The solution to this is to unmerge the cells then fill the empty cells with the first value of each data set. Now, if there aren’t that much data, you would probably just use the autofill function manually to accomplish this.

Fill empty cells with value above

But what if you have 1000s of rolls of data?

In this video, it shows how can be done automatically without any fancy equation. Check it out!

Referencec: https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/

Watch This Video - Easy To Rank Keyword Database


Easy To Rank Keywords for Niche Sites

DRM robot Learn More >>

Leave a Reply