Max:

On second thought, I might try and convey the issue in the example below.

Column A has colors
Column B has names
Column C has numbers
Column D also has numbers

A B C D

Red Jack 7
Red Jack 3
Blue Bill 1
Orange Bob 5
Red Steve 3
Blue Bill 7
Black Ron 8
Blue Ed 7
Orange Jack 4
Orange Jack 9

I would like to achieve the following combining the information (columns A,
C and D) for the same names in column B into a one line entry. I want to
also keep colors in column A; names in column B; numbers in column C; and
numbers in column D.

A B C D

Red Jack 7 3
Blue Bill 7 1
Orange Bob 5
Red Steve 3
Black Ron 8
Blue Ed 7
Orange Jack 4 9


Can this be done?

Thanks

Bill





"Bill" wrote:

Max:

I have one additonal aspect of that issue that I did not convey in the
original e-mail. It is a little difficult to show here because of limited
formating capability. If you are interested, I can send you a very short file
that would better capture what I am trying to accomplish. I would need your
e-mail. Mine is .

Thanks for the help Max.

Bill

"Max" wrote:

welcome, delighted that it worked for you
--
Max
Singapore
"Bill" wrote in message
...
Max:
This worked
Thank you
Bill


.