if formula to copy down values. .based on column b into column a

Hi Experts excel 2007

Need a formula to copy the values down in column a based on column b...so

column A.            Column B
abc.                         Abc
abc.                        Blank
abc.                        Blank
cde.                       Cde
Cde.                        Blank
cde.                       Cde
Who is Participating?
mvidasConnect With a Mentor Commented:

route217Author Commented:
Thanks matt for the feedback.
I thought I had put a line explaining what to do. Put my above formula into A2, and carry down. When there is a value in B, it takes that value, otherwise it copies whatever is above it. After copying down, copy and paste the values on top of the formula for the column A value to stay.
All Courses

From novice to tech pro — start learning today.