compare the first column and concatenate the second column
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
Is there any way that I can do it? Thank you very much!
Best regards,
--
George
|