The sheet provided is some kind of template which is not very useful. Perhaps add some data and expected results?
Be aware that merged cells are one of XL's worst features

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post