Hi all,
Recently I experienced the need to unmerge the text within the category block (often in columns C) as I needed to add an additional helper column for sumif or other formulas. However, when I did this I was unable to free up that column which was previously merged.
Has anyone found the same issue or a way around it?
My solution is merely delete the entire category block and re-create and merge whats needed. This doesnt break the timeseries data (column J onwards), but wondering if the unmerging is a challenge for others?
Cheers
Lance
Hi Lance,
I haven't experienced that problem. However, if you turn on cell shading do the unmerged cells still have shading applied to them? If they are empty but with cell shading that can indicate they still have formatting applied. If you then select all those cells (including total row, if any) and press delete, or go to Home -> Clear -> Clear All does that solve it?
Cheers,
James