Drop-down List for Customer Database

Hi,

I need to create a macro (or figure out some other way) to do the following:

If you look at the attached spread sheet you will see the first tab "Raw". This sheet contains customer information that is automated when someone signs up on a website. The problem is that when a customer selects more then one "Communication Attribute Description" the system makes a different row for each "Communication Attribute Description" selected.

Is it possible to create a macro that would remove duplicates and give me a drop down list in the "Communication Attribute Description" column that would show all attributes that were selected. For an example see the tab "Simple".

I have tried using VLOOKUP and IF functions to do this but I cant get to a solution that is easily readable and is time efficient.

Thanks for your help!