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!

One way is to insert two more columns and use the following formulas

[d2]=if(b2="",c2,b2)
[e2]=if(d2="",b2,d2)

and then copy it down.

and if you want to preserve the values copy pastespecial will do it.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"pm" wrote:

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!

Data Filter Auto Filter

Select a drop down on Base1, then select (Blanks). In Base 2 type ="the
cell of base 1", then copy all the way down as far as needed.

Do the same on Base 2


"pm" wrote:

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!

If b and c were the original partly completed columns, shouldn't [e2] be
=if(c2="",b2,c2) ? (c2 rather than d2?)
--
David Biddulph

"Martin Fishlock" wrote in message
...
One way is to insert two more columns and use the following formulas

[d2]=if(b2="",c2,b2)
[e2]=if(d2="",b2,d2)

and then copy it down.

and if you want to preserve the values copy pastespecial will do it.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"pm" wrote:

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!