Cut / Paste with a Twist

H

hstockbridge5

Hi,

I need a procedure that will move values from one column to another,
but only if the value is not null. The raw data looks like this...

Title Title_Other
Nurse
Other (Please specify) Radiologist
Tech
Other (Please specify) P.A.

... and in the end I need it to look like this...

Title Title_Other
Nurse
Radiologist
Tech
P.A.

Any help you can lend would be appreciated.

Henry
 
M

mrice

A neat way of doing this is to create a thrd column which contains
concatentation of the first two. e.g.

= A1 & B1 in cell C1

This has the effect of making a single column
 
M

mrice

A neat way of doing this is to create a thrd column which contains a
concatentation of the first two. e.g.

= A1 & B1 in cell C1

This has the effect of making a single column.
 
M

mrice

A neat way of doing this is to create a thrd column which contains
concatentation of the first two. e.g.

= A1 & B1 in cell C1

This has the effect of making a single column
 
Top