Editing existing macro help

Hello, firstly many thanks for taking the time to look at my problem. I previously created a psuedoproblem, with an example of what i would like returned in the attatched excel doc. This psuedoproblem that was solved by Excel forum moderator "Leith Ross" and the button attatched macro works perfectly. Unfortunately due to not completely understanding this macros coding i have been unable to edit it to fit my needs (yes i should have supplied a more representative problem.) My Hope is that someone might be able to help me edit this code to work for the representitve example stating in row 110 of this page.

Any help provided will be gretly appreciated.

Many Thanks Alan