Hello there, I have a table looking like this:

Branch Date Sales ...
Covent 28 5555 ....
Leeds 28 354 ......


Covent 29 458 ....
Leeds 29 165 ...

I need to set up a filter or formula that based on the value in Branch,
would give me the remaining values in that row, but following the daet
sequence.

To look like:

Branch Date Sales ...
Covent 28 5555 ...
Covent 29 458 ...

Any advice?

Please