Remove merged cells so you can work with the individual cells within

How to switch off merged cells that prevent you from selecting specific cells within the merged area. Especially important if you need to fill in the blank cells with the one above so that each row contains all the relevant data.