I have hundreds of merged cells in column a. The merged cell is a header for the row data, but I need to unmerge the cells but have the header apply to the cells that are unmerged. When I unmerge the cell, the header defaults to the top row only of that section. I also have hundreds of merged cells in column a, of different titles, so I am trying to find a quick way to unmerge and place the header in all cells, find the next unmerged header and place that header in the blanks of the section, and repeat. Thoughts/formulas?