you're welcome and thanks for the feedback

--
Cheers
JulieD

"smb2000user100" wrote in message
...
Thank you! It works very well.

"JulieD" wrote:

Hi

a similar question was asked in microsoft.public.excel.programming
yesterday
.... my answer then was .....

use the advanced filter to generate a list of the unique ID numbers in
another column on your worksheet (Debra Dalgleish has notes on how to
do
this at www.contextures.com/tiptech.html) and then use a UDF that
Harald
Staff and myself created called CONCAT_IF to concatenate the keywords
...
this function and notes on using it can be found at my website
www.hcts.net.au/tipsandtricks.html

the OP of that question replied that the answer had worked well for him,
so
maybe it will also work for you

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"smb2000user100" wrote in
message
...
Hello,

My original worksheet is like:
ColumnA ColumnB
Category Code Keyword
BEQAB HAMILTON BEACH
BEQAB HAMILTON BEACH
BEQAB 00756|VITA MIX
BEQAF TOMLINSN
BEQBBP K7003NF|REGAL
BEQBBP K7001NF|REGAL

I want to get a worksheet like:
ColumnA ColumnB
Category Code Keyword
BEQAB HAMILTON BEACH|00756|VITA MIX
BEQAF TOMLINSN
BEQBBP K7003NF|K7001NF|REGAL

I cannot figure our how to get it. Please help me. Thank you very much!

Best regards,

--
George