Having a senior moment.

I want to place values in columns.

EG
A2=25 B2=sheep C2=A2 all other columns (except A & B) blank
A2=25 B2=dogs D2=A2 all other columns (except A & B) blank
A2=25 B2=cats E2=A2 all other columns (except A & B) blank
and so on