I have some data that comes out of our analysis in the following format:

Name Base 1 Base 2
Gina G
Ted A T
Tim C A
Norm T

So, sometimes there are values just for one base, other times both bases are
present. My question is for those that only have 1 entry, how do I duplicate
that entry in the empty column. For example, for Gina I would want to
duplicate the G in the base 2 column. Ted and Tim are fine, since they have
2 values already. For Norm, Base 1 should equal T as well.

Thanks in advance!