compare two cells, swap cell contents

[Jerry]

I want to compare account numbers in column A. If the numbers are the same
then I want to put the words found in column B into one cell in column C then
delete duplicate account rows.
135490 Yellow Yellow, Red
135490 Red
135490 Yellow

 

[Frank Kabel]

Hi
this would only be possible using vBA. Would this be a feasible way for
you?

 

[David McRitchie]

Hi Jerry,
This does not exactly do what you ask. Your example is not clear, but I
think I get the general idea. This will not prevent duplicates from
being included.

You can filter duplicate rows out with
Ctrl|A (select all), Data, Filter, advanced filter, [x] unique records only
The select what you see and paste it to another worksheet, because
only the visible filtered rows will be copied.

Joining Codes in Column B to a Product in Column A (#joining)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#joining