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