flex your data

Do you sometimes receive a file with merged cells all over the place? Something like this: The first thing I want to do in that situation is un-merge everything. Well, that’s easy enough. If I use the Merged Cells button on the ribbon, it will do this: Ok, now I need to fill in the blank rows with the category header from the top of each row. I can do that using the useful technique of Go To Special/Blanks and enter a formula. Like this: That is useful, but I don’t particularly like having formulas in those cells after I’m…