see below.
I have this: 2 columns
123456 123455
123457 123456
123458 123459
123459 123467
I want it like this:
123455
123456 123456
123457
123458
123459 123459
123467
If there is a match- i want it to be side by side, if no match - leave a
blank.
Thanks for you help.

--
Michele


"Otto Moehrbach" wrote:

It creates a blank where? Do you want cells moved to create this blank? Or
do you want some cell cleared to create this blank? HTH Otto
"Michele" wrote in message
...
I have a spread sheet that I am trying to compare item descriptions. My
column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have
is
CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to
sort or filter them so it the number is not in HSM but in 400, it creates
a
blank. Any input will be great.
--
Michele