Cut / Paste with a Twist
 

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

Cut / Paste with a Twist
 

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560004

Cut / Paste with a Twist
 

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560004

Cut / Paste with a Twist
 

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560004