Good morning, Pete-
I can help you write a macro, but I still don't follow your question.
Do you mind expanding your example table to include the "before" and
"after", which would show your desired results?