In your mock-up, you need to illustrate what you mean.

I am not totally clear on your description, but suspect that it may require VBA.

Please filter and manually highlight to show what we are aiming for.