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!