Formula Help - Please

Hi, I am struggling. I am trying to figure out a formula that accomplish the following results:                     Data                    A             B             Formula Answer Row 1     ...