Table format Conversion

I have a table with two columns "code" and "dates". There are duplicates in the code column but each duplicate has an corresponding unique date. I want to eliminate the duplicate codes and have the unique date values put next to each other under a single row for a given code word.

Example:
as 98
as 76
as 76
bc 54
de 32
rf 54

I want a table as:

as 98 76 56
bc 54
de 32
rf 54

I have also attached a sample sheet for further reference. Any help is appreciable.

Thanks

Hello ramanan256,

Here is another approach. This assume the data starts in cell "A2" of the active sheet. You can change the starting cell if you need to. It is marked in bold text below.

Please Login or Register  to view this content.

Hello ramanan256,

Oops, you did ask for that. Here is the corrected code. The changes are in bold text.

Please Login or Register  to view this content.