combine 2 columns

[Omar]

Dear Expert,
I have three columns one contain the name of 10 patients, the second
one contain the age of 5 patients , P1, P3 , P4 ,P6 , and P10 , the
third column contain the age or the rest patients ( P2,P5,P7,P8, and
P9).
The question is, how can I combine columns 2 and 3 in one?
Thanks.

 

[Mike H]

Hi,

To combine in column 2.

Select column 3 and right click and copy.
Select column 2 and then Edit|paste special|add and click Ok.
Delete column 3.

Mike

 

[MartinW]

Hi Omar,

One way
Assuming your data is in columns A,B and C then in D1
put =IF(C1="",B1,C1) and drag down as far as needed
then delete columns B and C

This also assumes that, if there is a value in column B, then
there is no value in column C and vice versa.

HTH
Martin