I need a script (macro) that will take all merged cells in a worksheet, unmerge them, then fill them with the text that was in the original merged cell. Multiple unique instances throughout the worksheet. Prefer a solution that would repeat this function for all merged cells within the worksheet.
Sanitized version of my spreadsheet is here:
Dropbox - Public
Sanitized version of my spreadsheet is here:
Dropbox - Public