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