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