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.

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.

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/

• Author
• Recent Posts

Tony

I am an SEO consultant who happens to be interested in affiliate marketing.
I build websites and use them for testing various SEO strategies and tactics.

LinkedIn Profile

Latest posts by Tony (see all)

• How To Track Keyword Ranking? - April 27, 2020
• Is Updating Old Content For SEO Worth It? - March 30, 2020
• What Is Remote Desktop Access (a.k.a RDP Or VPS) For SEO? - March 27, 2020